cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RomainPichon
Regular Visitor

Bad Request when using "Insert a row in an Excel spreadsheet when Microsoft Forms is submitted"

Hi,

 

I used the

"Insert a row in an Excel spreadsheet when Microsoft Forms is submitted" but when I run it, I've got the following message
BadRequest. in the "Insert row" step.
 
The french error message says a value must be provided for the element.\r\nclient...
{
"status": 400,
"message": "Une valeur doit être fournie pour l'élément.\r\nclientRequestId: 594885c3-3414-43cb-bc28-be4b7084f856",
"source": "excel-ne.azconn-ne-01.p.azurewebsites.net"
}
 
If I have a parameter "Row" with the name of a Forms field.
 
If I delete that parameter I have the following erros while building the flow :
 
Error while running the API "....
"Erreur lors de l’exécution de l’API « /$metadata.json/datasets/b!DV4jnOJIDEeWmgLhsqecdsPx69PoYyxGjqk_LNqDr5gkh9Taq1FXQa_EtKIn9KpL.014ILDLKJVHI3R23MTUBBJDU6VS5SAJPGC/tables/Sheet1 »
 
If someone could help me that would be great. I've been on it for 2 hours now and I'm really stuck.
I could not find the exact same issue on the forum.
9 REPLIES 9
v-alzhan-msft
Community Support
Community Support

Hi @RomainPichon ,

 

You could start a new flow and the issue could be solved.

 

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.

STill the same issue with a new request "OpenApiOperationParameterValidationFailed"

"Input paramater 'item' validationfailed in workflow operation 'Add_a_row_into_a_table'"

Hi @RomainPichon ,

 

Could you please share a screenshot of the configuration of your flow?

Could you please share the run history of the flow when the flow run failed?

 

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.

Workflow demande essai.PNG

Bad Request.PNG

 

@v-alzhan-msft these are the screenshots. The run history says it is OK. But since the step "insert row" failed every time it's not.

Hi @RomainPichon ,

 

Please choose the file from the Picker in the File field and choose an option from the drop down list in the Table field.

 

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.

@v-alzhan-msft 

"parameter path$.table is empty or has an "execution expression"...Inserted a field.PNG

 

Hi @RomainPichon ,

 

You shouldn't add the dynamic content in the Table field in the insert row action, the dynamic content is not supported in this action to get the table of the file.

You could only choose the table from the drop down list.

1.png

 

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.

No table name.PNG

The problem might come from here. It is written "no item" in the dropdown list.

Hi @RomainPichon ,

 

Have you created any table to the excel sheet?

https://support.office.com/en-us/article/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac6...

 

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.

 

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (86,196)