I'm having some trouble with a flow I'm using that is based on the "Register forms responses to a sharepoint list" model.
There are some multiple lines text fields on the sharepoint list, but they are not being registered for some reason.
The following print is from the "Get response details", where we can see the content of a long text field:
And here we can see that the "Create item" is properly set up.
However, it is still not being registered. Both the Forms field and the Sharepoint list field are set to "Multiple lines of text".
Any idea why this might be happening?
Thanks in advance!
Solved! Go to Solution.
Hey @fchopo, it seems like the problem was me all along.
On my forms, I have sessions with a single question, and they share the exact same name.
It turns out that PowerAutomate suggests the session name as dynamic content too for some reason, thus my confusion:
Forms setup (session + single question with the same name):
Dynamic content suggestion in Power Automate:
Basically, I was storing the session instead of the actual question on my sharepoint list, that's why it was blank.
That sums up the mistery.
Sorry for the trouble and thank you so much for trying to help me.
What do you mean by saying "they are not being registered for some reason.". Do you mean the text is truncated? Or the text is not stored and left empty? Is the flow executing ok or is there any other error? Could you provide more information?
Regards,
Ferran
Hey @fchopo, thanks for comming to my aid.
Second option, the text isn't stored and the sharepoint list field is left empty.
All other regular one line text fields work fine, and the flow executes normally, it just leaves some info behind.
As you can see in the prints, when getting response details, the field content is there, but it does not save it to the sharepoint list.
Any other info I could provide?
Hello @antoniohbarros
You can read this excellent blog post by Megan Walker: Retaining Line Breaks In Multi-Line Text Fields From Forms Pro - Megan V. Walker
You could use this expression and test it in your flow:
uricomponenttostring(replace(uriComponent(body('Get_response_details')?['r1023da0d92764a5a8bafaea47bf08572']), '%0A', '<br/>'))
where 'r1023...' is the multi-line forms field.
Hope it helps!
Ferran
Good morning! And sorry for the late reply,
I've been trying some other solutions aswell.
I've read the article you recommended, and followed it thoroughly.
Unfortunately that didn't work either, the multiple lines fields still won't be saved to the list.
Do you have any other ideas? This never happened to me before, so I'm considering opening a ticket to Microsoft.
Hey @fchopo, it seems like the problem was me all along.
On my forms, I have sessions with a single question, and they share the exact same name.
It turns out that PowerAutomate suggests the session name as dynamic content too for some reason, thus my confusion:
Forms setup (session + single question with the same name):
Dynamic content suggestion in Power Automate:
Basically, I was storing the session instead of the actual question on my sharepoint list, that's why it was blank.
That sums up the mistery.
Sorry for the trouble and thank you so much for trying to help me.