Unanswered

Populating a word template - ERROR: Failed to retrieve dynamic inputs. Error details: 'e.toLowerCase is not a function'

(0) Share

Report

Posted on by NickJayRay

I have built a flow, triggered when a form is submitted. It then reads data from an excel table. I want it to take data from the table and form to populate into a word template.

I have tried the flow WITHOUT the word template, and just using the dynamic data to send an email, and it all works fine.

When trying to populate the word template, I created a blank page with literally just the placeholders on it e.g. <<name>> which is the same as my dynamic data from Forms and Excel.

Everytime, I get the same error code - "Failed to retrieve dynamic inputs. Error details: 'e.toLowerCase is not a function'". I've googled every solution and chatted it through with ChatGPT. Connections are working fine, I can find my template, I've created a brand new template with only placeholders, even tried curly brackets. Can't get this final step to work.

Any suggestions would be greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (20)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @NickJayRay

Where you using this expression?

toLowerCase ()

Could you post a screenshot of your template and mappings and the error details?

Thanks

Was this reply helpful? Yes No
JTBright 35 on at

Like (0)

Report

Hello @abm ,

I'm getting the same error only I didn't use the code you reference. It's a simple form that I want to import to Sharepoint List and I get that error. Any ideas/help would be greatly appreciated. Thank you,

Was this reply helpful? Yes No
JTBright 35 on at

Like (1)

Report

Sorry here is a screen capture of my error

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @JTBright

See below why you having Createlist parameter here? You need your SharePoint address only here.

Was this reply helpful? Yes No
JTBright 35 on at

Like (1)

Report

I tried cleaning it up. Here is the resulting error.

Here is the path:

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @JTBright

That folder path is wrong. Click the right side icon against that text box. Browse and select the path.

Thanks

Was this reply helpful? Yes No
JTBright 35 on at

Like (0)

Report

Hello abm,
I did as instructed, got a slightly different error message:

Was this reply helpful? Yes No
JTBright 35 on at

Like (0)

Report

Hello abm,

This was obviously a case of user error. I started from scratch used your instructions and have successfully been able to save my workflow. Thanks so much!

Was this reply helpful? Yes No
JTBright 35 on at

Like (0)

Report

Now that the flow was successful, I need to add some of the questions to the output. How do I do that? I am using the Copilot to "Add items to Create Item" and leave it auto-populated. Here is the result:

Was this reply helpful? Yes No
JTBright 35 on at

Like (1)

Report

To be transparent. The activity I am trying to complete is taking an MS Form, uploading it to list, and sending an email.

This is the example I was following but obviously ran into issues as it maybe a little out of date in some places:
https://blog.crgroup.com/power-up-with-power-apps-extracting-data-from-microsoft-forms-into-sharepoint/

Thank you,

Was this reply helpful? Yes No