You’re offline. This is a read only version of the page.
25
Hi all,
Struggling to work out what to do next here... I've got a flow where I need to update 4 property fields in a SharePoint document library for an excel file as soon as it is uploaded.
So far, I've got the trigger to run as soon as a new file is uploaded, access the excel file and create a 2 column, 4 row table (5 with headers) which contains the data I need. I then run the 'list row present in a table' step to get all of the data I need.
Next step - I need to know how to enter the 4 pieces of data into the corresponding property fields... when I try to run an apply-to-each using the output from 'list rows...' I do not see the field names from my table. Clearly I've missed a step or I'm going about this the wrong way - can anyone lend a hand?
Many thanks in advance!
I see, thanks for the clarification.
You should use a Get tables activity after creating a table. This should create an apply to each loop, than use the List rows present in a table activity and use the dynamic table name you get from Get Tables activity.
Now this should retrieve values and you can use create item activities to pass values around to sharepoint.
Good luck.
I don't think I've explained my issue properly - When I come to update the properties of the record, I just don't see the table fields from within the Excel file so I can't update the properties with the values from this table.
Thanks - I've tried to use the 'Update File Properties' activity but I don't see the output from the 'List Rows Present in a Table' activity... I only see the content from 'Create Table' or the 'When a File is Created (properties only)' activity.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
