cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Straight forward Microsoft form to Sharepoint list

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:

first.PNG

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.

second.PNG

 

 

third.PNG

 

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

 

Regards,

8 REPLIES 8
Highlighted
Super User
Super User

Re: Straight forward Microsoft form to Sharepoint list

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




Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up ?


Proud to be a Flownaut!





Highlighted
Microsoft
Microsoft

Re: Straight forward Microsoft form to Sharepoint list

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? 

Highlighted
Helper II
Helper II

Re: Straight forward Microsoft form to Sharepoint list

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.
fourth.PNG

 

 

fifth.PNG
 
Thoughts??
 
Regards,
Highlighted
Microsoft
Microsoft

Re: Straight forward Microsoft form to Sharepoint list

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? 

 

form peek code.JPGcode ms form.JPG

Highlighted
Microsoft
Microsoft

Re: Straight forward Microsoft form to Sharepoint list

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

Highlighted
Helper II
Helper II

Re: Straight forward Microsoft form to Sharepoint list

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. eight.PNG

 

nine.PNG

tenth.PNG

 

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

 

Regards,

Highlighted
Super User
Super User

Re: Straight forward Microsoft form to Sharepoint list

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




Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up ?


Proud to be a Flownaut!





Highlighted
Helper II
Helper II

Re: Straight forward Microsoft form to Sharepoint list

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

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Kudoed Authors
Users online (10,751)