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 ready 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.
That is a limitation with the excel connector. It does not like values for the filename and the table being passed dynamically or during run time.
You might want to try using the graph API for this: https://docs.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hey @ChristianAbata ,
I tried Compose as well as Initialize Variable action but none of them seems to work. It seems some kind of bug.
Actually, that is not correct. Excel does support dynamic values in for the File parameter but in the Flow designer it inconsistent. According to official docs https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/#known-issues-and-limitations
The File property expected by the connector's actions should be filled using one of the following options:
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!