Straight forward Microsoft form to Sharepoint list

[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,

[Jcook]

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

[Yeiner]

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? 

[fklatecki]

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,

[Yeiner]

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? 

[Yeiner]

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

[fklatecki]

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,

[Jcook]

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

[fklatecki]

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