Importing data from Microsoft Forms to Sharepoint List

(0) Share

Report

Posted on by CarolinaSanchez

Hello,

I have a flow that takes data from Microsoft Forms and brings it to Sharepoint List upon approval.

The problem I am having is that for one of the Form text fields (long answer), when the user enters a comma in the Microsoft Form, the information for that field is not brought into the Sharepoint List. However, when there is no comma, the text is brought into the Sharepoint List.

The column type in Sharepoint List is "mutiple lines of text". Any ideas on why this is happening?

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

Hey Mate,

In SharePoint Multi line text column property please set it to "plain text".

Then run your Flow see if that gives you better results.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
CarolinaSanchez 10 on at

Like (0)

Report

Thanks @CFernandes . These settings are already there:

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

Hey @CarolinaSanchez

I could not reproduce the problem -

SPO list -

My Flow -

Can you check if the values in the Multiline text column are populated properly in Flow(you can check my screenshot for your reference).

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
CarolinaSanchez 10 on at

Like (0)

Report

Thanks @CFernandes . When I look at the raw inputs, the field is not populated. However, we are no longer experiencing the challenges when there are commas, but we still have the issue that sometimes the data is not brought into the Sharepoint List... it works sometimes, but it doesn't work all the time...

Was this reply helpful? Yes No