Power Platform Community Forum Thread Details

Getting Column Name/Value From Excel File To Update SharePoint List After Creating Table

Hello all. I have a flow where I am duplicating an excel file from a network drive to OneDrive for Business and then creating a table in said excel file (there isn't a table when I duplicate). From there, I list the rows present in the table.

It is important to know, when building this flow, because there is no table in the file until the flow runs, that I had to use variables to store the name of the file and table (file name is generated using guid() function to generate random name).

Next, I am getting the items from my SharePoint List that I want updated based on the newly created table in the duplicated excel file. Inside the Update Item action to update the SharePoint List, I don't have any dynamic content to use for the excel table because it doesn't exist (yet). So normally, the Dynamic content available in a flow where you List Rows Present for an excel table, you will have the Column Names which contain the actual values.

I am guessing I need an expression. So, one of my column names from the excel file will be 'Material Number'. How could I write an expression to get the values from the excel file 'fileName' and table 'tableName' for column 'Material Number' to update the SharePoint item?