Straight forward Microsoft form to Sharepoint list

(0) Share

Report

Posted on by fklatecki

Greetings,

I have simple MS Form that I would like to write the values to a SharePoint list, I am an admin.

I can map the Title, without issue using the dynamic content:

When I drop into the next field, the dynamic content is restricted to "When a new response Response Id", this is not consistent with all of the fields.

I would appreciate any help with these 'hide and seek' fields?

Regards,

Categories:

Using connectors

I have the same question (0)

All responses (8)

Answers (0)

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello,

Could you try putting in the values you want to capture in a Compose action before the SharePoint action.

The Compose action can be found in Data Operations connector.

Than in your SharePoint action use the referenced Compose actions.

Also confirm that the data types match. From Forms to SharePoint

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
yeinerlop on at

Like (0)

Report
Copy link

Link copied!

Hello @fklatecki When you drop into any other field, are you able to see "top line sales" ? Is there a way that you can create a new flow using a template?

Was this reply helpful? Yes No
fklatecki 65 on at

Like (0)

Report
Copy link

Link copied!

Greetings,

Thank you very much for your suggestions however, I am unable to get past the intermittent field mapping. I have double checked the fields would contain, the same data types, i.e. number or text.

I even inserted a Parse Json, to obtain,
{
"responder": "anonymous",
"submitDate": "2/17/2020 5:16:13 PM",
"r34aac99740cd435b9ab8d08a9725a366": "350",
"ra73807103bf54c72ba4f25f7cd34f38d": "100",
"rf7c09c899fba48cc9b667d361467112b": "Frank C Klatecki",
"rf292f9c39e6e46c58a565aebe9f274a9": "fklatecki@indeal.org",
"r3770f80dd8ee435fa9ba435af7bce7cd": "Corporate",
"r17e6da320a0941e480a17523a399b3ac": "5",
"r13697840a29448ba96fac1a2089ff973": "2",
"r8e701fd0dd6c4f369d9cf2bb75761ac6": "A test company"
}

However, in the attempt to map to SharePoint, I get the same fields limiting the view of even the Parse Jason dynamic content.

Thoughts??

Regards,

Was this reply helpful? Yes No
yeinerlop on at

Like (0)

Report
Copy link

Link copied!

Hello @fklatecki could you please send me the "When a new response is submitted"code from the template and from the flow that you created from scratch?

Was this reply helpful? Yes No
yeinerlop on at

Like (0)

Report
Copy link

Link copied!

Hello @fklatecki Also, I would like to know if this is happening only with a specific form or you are facing this behavior with all your forms

Was this reply helpful? Yes No
fklatecki 65 on at

Like (0)

Report
Copy link

Link copied!

Greetings,

I was able to create a new test Form, and SP List. Once again, I can connect dynamically with only two of three fields. The third field in the Form and column SP happen to be numbers? Hours being a number of course.

I appreciate the time you are spending on this tiny issue...

Regards,

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello,

Can you try my suggestion with Compose,
And compose each answer before the SharePoint action.

This could help troubleshoot what is going on

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
fklatecki 65 on at

Like (0)

Report
Copy link

Link copied!

Not families with compose syntax, can you give syntax after “ compose “?

Was this reply helpful? Yes No