Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Straight forward Microsoft form to Sharepoint list

(0) ShareShare
ReportReport
Posted on by 65

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,

  • fklatecki Profile Picture
    fklatecki 65 on at
    Re: Straight forward Microsoft form to Sharepoint list
    Not families with compose syntax, can you give syntax after “ compose “?
  • Jcook Profile Picture
    Jcook 7,770 on at
    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
  • fklatecki Profile Picture
    fklatecki 65 on at
    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,

  • yeinerlop Profile Picture
    yeinerlop on at
    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

  • yeinerlop Profile Picture
    yeinerlop on at
    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

  • fklatecki Profile Picture
    fklatecki 65 on at
    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,
  • yeinerlop Profile Picture
    yeinerlop on at
    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? 

  • Jcook Profile Picture
    Jcook 7,770 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics