Specific user can not be found while running PowerAutomate on Sharepoint

Attila Ihasz 25 Reputation points
2023-09-07T12:04:17.43+00:00

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).Flow

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

Thanks
Attila

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,151 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
545 questions
0 comments
Accepted answer
  1. Emily Du-MSFT 43,511 Reputation points Microsoft Vendor
    2023-09-08T07:43:26.97+00:00

    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.

    1

    2.Create a flow.

    In the select action:

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

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

    2

    3.Result:

    User's image

    User's image

    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.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Pascal 86 Reputation points
    2023-09-07T13:17:50.7666667+00:00

    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

    0 comments
  2. Attila Ihasz 25 Reputation points
    2023-09-07T18:03:29.3466667+00:00

    Hi Pascal,

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

    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?

    0 comments