You’re offline. This is a read only version of the page.
Announcements
I have an Excel table inside a workbook which is used for integration with Dynamics 365 as follows:
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.
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...
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
Share
Report
All responses (
Answers (
14,756
