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

[Farshadn]

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 detailsand I gave that variable to the email claims

The flow test:

This is how flow worked

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

[Expiscornovus]

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.

[Farshadn · Accepted solution]

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.