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 / How to assign a SP lis...
Power Automate
Answered

How to assign a SP list item to a person based on the text field of a MS Form?

(0) ShareShare
ReportReport
Posted on by 11

Hello everyone!

I have a Microsoft Form with a text field for collecting email addresses. Following each submission, an entry is added to a SharePoint (SP) list. I aim to assign the submitted form to a person based on the email text field. To achieve this, I established a person-type column in my SP list. In the Power Automate flow, I utilized "i:0#.f|membership|personemail" to pass the value to the designated column.

While the flow executes successfully, the Assign to column remains empty and doesn't display the assigned person. How can I address this issue?

 

Here I added that text field containing the email address into the variable value:

The formula I used to get the person's detailsThe formula I used to get the person's detailsand I gave that variable to the email claimsand I gave that variable to the email claims

The flow test:

This is how flow workedThis is how flow worked

 

But the person column does not show the person But there is no result in the person columnBut there is no result in the person column

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,773 Most Valuable Professional on at

    Hi @Farshadn,

     

    That format for the claims field looks fine. And as you demonstrated, it has found that profile. 

     

    Have you customized the form with PowerApps or in another way? Or is it it just a vanilla setup of the form?

     

    And just to be sure, the ID of the SharePoint list item of the flow test run is the same as the one in your last screenshot? I would suggest to include the ID column in the view so you can always make sure you are double checking the correct item.

  • Verified answer
    Farshadn Profile Picture
    11 on at

    Hi @Expiscornovus 

    Thank you for taking the time to investigate the issue. I was able to resolve the problem by recreating the flow using the old version of Power Automate, rather than the new UI. It seems there may have been a bug associated with the new UI.

     

    Thanks again.



    Thanks again.

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!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 283

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard