Table from a file (CSV/Excel)

In the portal, under Environments, click Development, and there Open. Flow opens in a new tab.

Click ＋ next to General and choose Table from a file. A window opens that takes you through reading the file in four steps: file, columns, security and import.

Click the box and choose your CSV or Excel file (dragging works too). Flow recognises the separator itself and shows the first rows, so you can see whether it looks right.

Flow proposes a name and a kind for every column, based on what is in it: amounts become Number, dates Date. A column with only a few different values, like the status, gets those values as a fixed list. Give the table a name that says what it holds.

The classification says how sensitive the data is; Internal fits a customer list without anything special. Here you can also set per role who may read or change; you can do that later as well.

Flow sums up what will happen. Every row is checked; a row that does not fit is skipped and reported, so you know exactly what did not come along.

Open the table: every row is there, with the right kind per column. From now on it works like any other table: you can change rows, use it in a workflow or publish it as an API.