You’re offline. This is a read only version of the page.
Announcements
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?
Dear ztb97,
I have done something similar and it can be done ... although it took me several versions of a the flow across several months. As you mentioned, the key is to figure out the expression and structure to use.
For me the following video was a real eye-opener, hope it helps you too. It will show you a good example of dynamically using data/files for files created on-the-fly in the same flow.
https://www.youtube.com/watch?v=RB_ySjhm9Sg
Happy flowing,
Koen
If this has helped, please like the video for the creator and set this answer as 'solution' in the thread for other users.
Share
Report
All responses (
Answers (
1,757
