Unanswered

Update Multiple Excel Files

(0) Share

Report

Posted on by crirojsab

Hello!

I'm trying to create a flow to update a SharePoint list every time an Excel File in a document repository is updated. For this start the flow when an item is created or modify. Then do a compose of the body and execute a JSON to get a better view of the different variables to used. Finally when tried to list the rows present in a table to continue at the time to execute the flow is saying "No Table named RootData is present in the file" when is there. Can you please help me?

Thanks for the help.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello @crirojsab ,

the action 'List rows present in a table' needs the file Id, not the file name.

Was this reply helpful? Yes No
crirojsab 89 on at

Like (0)

Report

Hi Tom:

Thanks for the replay. Tried ID as you suggested but I'm still getting the same error.

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello @crirojsab ,

then try to look for the file 'Identifier' and use that one.

Was this reply helpful? Yes No
Verified answer

crirojsab 89 on at

Like (1)

Report
Hi Tom:

At the end I found that pass dynamic content for the used of excel files is not valid and there is one request to solved this since 2018.

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Allow-for-dynamic-quot-file-quot-value-for-excel-quot-get-a-row/idi-p/103091#comments

However reading all the comments found that another couple of users Azman and AlisterT found an excellent work around and seems that is working now. Sharing the findings as you have to used the GIUD instead of the FileID:

GUID of the file:
SharePoint - Get file properties (Pass in the ID value from the trigger)
Compose - encodeUriComponent(concat('/',body('Get_file_properties')?['{FullPath}']))
SharePoint - Get file metadata (for the file identifier, pass in the output from compose action)
Excel Online Business - Get a row (for File, pass in the Id value from Get file metadata action)
Thanks for your help because at the end you gave me an excellent hints to continue with the search.

Was this reply helpful? Yes No