Unanswered

Error when running Excel script parameter name error

(0) Share

Report

Posted on by ChrissyRamirez

107

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.

@creativeopinion

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
ChrissyRamirez 107 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ChrissyRamirez 107 on at

Like (0)

Report
Copy link

Link copied!

@creativeopinion can you give me a little guidance on the above error?

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (1)

Report
Copy link

Link copied!

@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.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
ChrissyRamirez 107 on at

Like (0)

Report
Copy link

Link copied!

Thank you. I was using the ItemID instead of FileContent

Was this reply helpful? Yes No