web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate flow he...
Power Automate
Answered

Power Automate flow help needed

(1) ShareShare
ReportReport
Posted on by 153

I can use some help with a power automate flow. I have a Microsoft form that employee will fill in their training id. I need to capture the id from Microsoft forms and insert it into my flow to update an item in SharePoint.

 

Picture of question in Microsoft forms

JohnH70_1-1704729151857.png

 

 

Below Picture;

"Get Item" only the "ID" needs to be dynamic (training id) that is entered into the Microsoft form. 

 

I think I can achieve this by an expression, but not sure what expression to use.. If any one can help it would be much appreciated. 

 

(This flow works if I enter the training id manually, "1 - Thru -100")

 

JohnH70_0-1704728345936.png

 

Categories:
I have the same question (0)
  • trice602 Profile Picture
    16,071 Super User 2026 Season 1 on at

    Hi @JohnH70 ,

     

    Great start here!  I think you need to use Get Items vs Get Item.  That's because the "id" field is for the SharePoint ID, not your form training ID.

     

    So use Get Items and then filter it to the training ID column equals the dynamic content of the form training ID - this is going to give your the item you want to update.

     

    Then update your item.  Your ID in the update item is the dynamic ID from Get Items.  Then update your training ID and other questions from the form as needed.

     

     

  • Verified answer
    creativeopinion Profile Picture
    10,508 Moderator on at

    @JohnH70 The Id field in the Get Item action must be an integer. The value you returned from your MS Form must be converted from a string to an integer.

     

    Use an expression. Insert the int() function.

    creativeopinion_0-1704729734897.png

    Click on the Dynamic content tab and select the appropriate dynamic content from the Get response details action.

    creativeopinion_1-1704729811084.png

    Run a test.

     

    You might also be interested in a new YT Tutorial I recently uploaded: How to Get a Microsoft Form RSVP Response into a SharePoint List

    I cover the following in this video tutorial:

    ✅ How to get a Microsoft Form Response into SharePoint

    ✅ How to get a Microsoft Form ID

    ✅ How to get a Microsoft Form response

    ✅ How to Build a Microsoft Form with Conditional Fields

    ✅ How to used Branching in Microsoft Forms

    ✅ How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column

    ✅ How to parse a Microsoft Form multiple choice response as string of text

    ✅ How to convert a text response to a number

    ✅ How to use the Switch action

    ✅ How to create a custom email confirmation for a Microsoft Form submission

    ✅ How to Create a Custom View in a SharePoint list

    ✅ How to use the Compose Action

    ✅ How to write Power Automate Expressions

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution ✅.
    Consider giving me a 👍 if you liked my response!

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok

     

  • JohnH70 Profile Picture
    153 on at

    Trice,

    I tried your suggestion with "get items" instead and the query failed. Says invalid expression. But it has the correct number from the forms of "100" . So close but it still doesn't like something  to start the "update item"

    JohnH70_0-1704732892444.png

     

  • trice602 Profile Picture
    16,071 Super User 2026 Season 1 on at

    Hi @JohnH70 ,

     

    So looks like you just need to modify the filter query.  The format is like this:

     

    TrainingID eq 'dynamic_content_from_form_question'

     

    TrainingID is the column name in your list (whatever that is) and inside apostrophes, you put in the dynamic content for the form question (for 100 in your example).

     

    Save, and retest.  Should be good to go.

     

     

  • JohnH70 Profile Picture
    153 on at

    It still not working, is this formula correct? ... The training id is in the "ID" Column of the employee list. 

     

    JohnH70_0-1704742827053.png

     

    Flow shows as a success but it is not updating the SharePoint list. 

     

    JohnH70_1-1704743079115.png

     

    It won't let me see the data in the summary for the update it has a check mark so I can't tell what is failing. But it does have the "100"

     

    JohnH70_2-1704743259454.png

     

     

  • JohnH70 Profile Picture
    153 on at

    This works and did update the item but it put in the training id into the cell not the number from form which would be level "1" in this case. 

     

    JohnH70_5-1704744638836.png

     

     

    from microsoft form

     

    JohnH70_4-1704744374985.png

     

    any thoughts? how to correct?

     

     

  • JohnH70 Profile Picture
    153 on at

    This actually fixed my issue i needed to change my dynamic information back to original and this solution works like a charm .... Thank you so much!!!

  • JohnH70 Profile Picture
    153 on at

    The solution above actually has taken care of the issue. I do appreciate your assistance in this and hope you Monday is going well. 

  • trice602 Profile Picture
    16,071 Super User 2026 Season 1 on at

    Likewise John!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard