Specific user can not be found while running PowerAutomate on Sharepoint

Question

Hello,

There is an ongoing issue with my Power Automate workflow which apparently can not be solved at all. I have a site on Sharepoint in a list called "Documentation Request". Three times a week, I receive an excel (macro enabled) file from our customer service which contains the new documentation request for each user. I've created a flow which creates the Sharepoint items automatically. Most of the time the flow runs successfully, but there are cases when it stops because it doesn't a specific user.
We are talking about only 4 people, the same 4 people must receive their tasks. I've tried using their emails, their name in the database, everything the error keeps popping up (The specified user could not be found).

Any idea how to fix it? What did I set up wrong?

Thanks
Attila

Answer 1

Based on your description, I understand that the flow gets an error when import users form excel file into SharePoint person column.

You could follow below steps to create a flow.

1.Create a excel file.

2.Create a flow.

In the select action:

From split(items('Apply_to_each')?['Owners'],';')

Map Claims i:0#.f|membership|@{item()}

3.Result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

If you have a column of type "Person" in SharePoint, the connector asks for the claim of a user.

The format for claims is: "i:0#.f|membership|email@domain.com"

So in the Create Item action in your picture you could try to add "i:0#.f|membership|" in front of the Owner field (which I suppose contains the email address only).

Also this thread might help you in that regard:

https://powerusers.microsoft.com/t5/General-Power-Automate/Assign-to-Claim/td-p/1517035

Answer 3

Hi Pascal,

I've followed the instructions you provided. Added the "i:0#.f|membership|" in front of the "Owner" field, result:

The flow has been running for over 4 minutes now (it only contains 2 rows which has been already uploaded earlier today under 3 seconds).

Thanks for your swift response though.

Any other ideas?