News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Unable to Read values ...

Power Automate - Building Flows

Unanswered

Unable to Read values from 'Excel Get a row'when using dynamic value for File

(0) Share

Report

Report

Posted on by salmanlari

I have an Excel table inside a workbook which is used for integration with Dynamics 365 as follows:

Annotation 2020-04-19 200158.jpg

I have a flow whose trigger is SharePoint "When a file is created or modified (properties only). I want to Read a row in Excel for Business but the problem is that when I pick the file using Browse (hard coded) I am able to read the values but, as soon as I use the 'Identifier' (dynamic value) from the trigger the variables below stop showing the Excel action in dynamic values as shown in the follow picture. Please note that I am dealing with multiple copies of Excel sheets.

All responses Img

All responses (1)

Answers Img

Answers (0)

efialttes 14,756 on at

Like (0)

Report

Re: Unable to Read values from 'Excel Get a row'when using dynamic value for File

Hi!

Is the identifier you stored on your SP list the same 'File identifier' output provided by 'When a File is created in a Folder' or 'For a selected File'?

I have tested it only with 'List rows present in a table' but... if the answer is yes, I would have expected your approach succeed...

https://powerusers.microsoft.com/t5/Building-Flows/Copy-excel-contents-from-email-attachment-to-another-excel/m-p/496257/highlight/false#M61647

Anyway, there is a great workaround suggested by the even more great John Liu. 'Send HTTP request to sharepoint' should do the magic. Again, tested only with 'List rows present in a table', so not 100% it will succeed with your action block

http://johnliu.net/blog/2019/5/workarounds-needed-to-use-the-excel-connector-in-microsoft-flow

Hope this helps

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#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

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans