Answered

Making flow form Forms to SharePoint

(0) Share

Report

Posted on by Agata1

I want to create a flow where, upon receiving a new response in MS Forms, it creates an item with those responses in a SharePoint list. I've created a list item in SharePoint and set the appropriate data types in the columns: text and number. When creating the flow in Power Automate, I can connect the relevant question from MS Forms to text fields, but not to number fields. I have several flows that work in this manner. What could be wrong in this case?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Agata1 ,

Do you mean you cannot put answer to number column? What is the type of the question?

Are there any screenshots about your problem?

Best regards,

Rimmon

Was this reply helpful? Yes No
Agata1 4 on at

Like (0)

Report
Copy link

Link copied!

Here are screenshots. The second screen pertains to the number column type. Power Automate doesn't provide me with the option to select the question from which to pull the response into the SharePoint list.

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Agata1 ,

This is because the PA automatically recommends a value of the same data type, and since the Response Id is a value of type number, it appears in the available dynamic content of the Number column.

I recommend you use int or float to convert text type answer to number.

For example.

int(select your answer dynamic content here)

Best regards,

Rimmon

Was this reply helpful? Yes No