I am using the following Excel Online (Business) actions: Get worksheets, Create worksheet, Create table, List rows present in a table, Get a row, Update a row.
All of these actions work with dynamic content code inside the *File identifier field.
The action "Add a row into a table" action is giving me an error and causing the flow to fail.
When I put the "Identifier" dynamic content into the field, or when I compose the identifier, or when I put the file path, etc... all of it fails with this error code:
{
"status": 400,
"message": "The expression \"[REDACTED]" is not valid.\r\nclientRequestId: [REDACTED]",
"error": {
"message": "The expression \"[REDACTED]" is not valid."
},
"source": "excelonline-eus.azconn-eus.p.azurewebsites.net"
}
However, when I manually choose a file by clicking on the folder icon (as in the picture below), the flow suddenly works.
I need the File identifier field to work dynamically just like every other Excel actions I am using.
Why is this action in particular failing; why is it different than the rest when it looks like it is setup the same?
The others are working as intended.
Someone please help! ❤️
Solved! Go to Solution.
Hi @Reylin ,
I have made a test on my side and the issue is confirmed on my side.
I'm afraid that the identifier dynamic content is not supported in the "List rows present in a table" action in Microsoft flow currently, I suggest that you submit an idea to flow ideas forum if you would like the function to be supported in Microsoft flow:
https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/MPAIdeas
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Reylin ,
I have made a test on my side and the issue is confirmed on my side.
I'm afraid that the identifier dynamic content is not supported in the "List rows present in a table" action in Microsoft flow currently, I suggest that you submit an idea to flow ideas forum if you would like the function to be supported in Microsoft flow:
https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/MPAIdeas
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think the Identifier variable is internal for use in processing file data in Flow, if you want a string output maybe try the ID variable.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
32 | |
28 | |
27 | |
21 | |
10 |