Power Platform Community Forum Thread Details

Hello Power Users,

I have an excel sheet with multiple tables in it. I would like to grab a selected table of those two. I had the actions used as named below.

Action One (Trigger) : When a file is created or modified (properties only)

Action Two : Get file content (Site Address, File identifier (Identifier) and infer type (yes)

Action Three: List rows present in a table. (Location : Site address, Doc library : LibraryName, File : Name from trigger and Table : Variable(TableName)

Tried initializing variable with the table I want and inserted in Table in action three. Result : Failed

Tried inserting custom value. Result failed.

Can anyone please suggest or best way to handle such cases.

Thank you so much in advance!

Categories:

Building flows

Hi @KrishR

Pls refer the below sample flow.

Here I have used a variable "ExcelSheetTableName" that stores the table name and set its value as 'Table1':

Next, we will use "Get tables" action to fetch all the tables from the excel file uploaded on the SharePoint:

We will use "Filter array" to filter the table name from the array return by previous step:

Finally, pass the first element of output of "Filter array" action which gives the name of the table from where data needs to be pulled from. We need to write an expression to get the table name. Expression needs to enter in the expression window as highlighted in the below screenshot:

Expression used for getting table name:

first(body('Filter_array'))?['name']

This way, you can read the records dynamically from the excel sheet uploaded on the SP library. I hope this will give you some idea to design the required flow.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks