cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Reylin
Advocate II
Advocate II

Excel Online (Business) 'Add a row into a table' action failing *File Identifier code while other Excel Online (Business) actions are working smoothly.

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. 
nAAjIHW.png

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. 
0LCQnNV.png


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! ❤️ 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-alzhan-msft
Community Support
Community Support

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.

Luber
Frequent Visitor

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.
Screenshot - 12_11_2020 , 6_06_24 PM.png

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (1,404)