I have been working on this flow for sometime. The flow takes the information from a form, processes the inforamtion, creates a excel file in a sharepoint group and runs a script to fill in the excel sheet. I am getting the below message but I am unsure how to fix the issue. The error appears on the run script step. The issue is below:
In your 'Compose-Price-Total' expression, it seems that you are referencing the 'r34c41f014a134af48355a2eaf5f24109' parameter from the 'GetFormResponseById' operation. However, the correct parameter name is 'r34c41f014a134af48355a2eaf5f24109'. Please double-check the parameter name and make sure it matches the correct parameter name in the 'GetFormResponseById' operation.
Thank you. I was using the ItemID instead of FileContent
@ChrissyRamirez I believe you are using the incorrect dynamic content in the File field. Refer to my YT Tutorial: How to DYNAMICALLY Select a Table in the List Rows Present in a Table Power Automate Action
In this tutorial I cover how to use a dynamic value in the File field of the Get Tables and List Rows Present in a table action. This should also work for the Run Script action.
@creativeopinion can you give me a little guidance on the above error?
After I was able to move to the classic designer, I received a different error.
The file format is not recognized. Please check that the selected workbook is valid.
clientRequestId: 575f7728-367e-44ec-bb47-21ad385a2183
@ChrissyRamirez Have you tried editing your flow in the Classic Designer? The new designer is still buggy especially with the MS Form Trigger and action.
Try to toggle off the New Designer and re-insert your dynamic content and see if that helps.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2