Skip to main content

Notifications

Community site session details

Community site session details

Session Id : XDsWivIRp6ZeKCk+40feMy
Power Automate - General Discussion
Unanswered

Import Excel table to a Sharepoint List

Like (0) ShareShare
ReportReport
Posted on 13 Jun 2024 12:35:02 by

Hello everyone, 
I'm new in power Automate and have some difficulties to apply the recommendations found in this forum. I know that some solution are already provided to my concerns in this forum but I'm just not able to apply them. Sorry for that 😞

 

Let me explain:
I have an excel sheet with lot of user emails columns and want to import them in multi person/ group columns.
Only the records 100% completed are imported and rows with some blank or user email info not correct are not imported.


I started to create a condition for my first multi person/group but tried lot of things without success!
Can you help me on that ? I suppose I will have to copy / paste the solution for all person/ group ? or we have a global solution ?

 

Second problem:
When we import some user emails and they don't exist in my organization, I also have an error which stop the process.
How can I check for all person/group if the email is correct in our organization?
PowerAutomate-image1.jpgPowerAutomate-image4.jpgPowerAutomate-image3.jpg

Thank you a lot in advance for your help

  • DGPowerAutomate Profile Picture
    on 18 Jun 2024 at 06:40:27
    Re: Import Excel table to a Sharepoint List

    Hi SudeepGhatakNZ
    Thank you for your feedback. Unfortunately, defining a person/ group field as null won't help me because during the 'create item' process it will fail. All tests done before the create item to verify if the field is empty or null is rejected during the 'create item step.
    a person/ group field cannot be empty, null or a person who won't exist in the organization.
    My problem is linked to the fact I gave 7 columns with multi person/group per row.
    So I can use array to verify if the user exists in the organization, check if empty, etc ...  without problem.
    But during the create item step, I'm obliged to use the result of the arrays to create the row also when a field person/group is empty else the row won't be created and it is where I don't know how to do
    So, no solution found at this moment. 
    I think I have to import my person/ group field as a 'text field' to support the blank option 😞

  • SudeepGhatakNZ Profile Picture
    14,292 Most Valuable Professional on 15 Jun 2024 at 23:28:10
    Re: Import Excel table to a Sharepoint List

    Try this

    if(empty('Person Field',null,'Person Field')

    SudeepGhatakNZ_0-1718496968626.png

     

     

  • DGPowerAutomate Profile Picture
    on 15 Jun 2024 at 10:22:53
    Re: Import Excel table to a Sharepoint List

    Hi guys, I did some progresses on this topic, so I'm fully able to test if a person field is empty or not but the problem s still there!

    So, just think I exactly know if my Site BRM Contact or all other columns from Excel are empty or not.
    A variable strBRM, strLocalContact , etc are defined with '' in case of empty or with the value (email) if not empty)
    But at the end I need to create the row with all info.
    How to 'create item' with all results of my variable ... I obtain an error because at the end, I try to create an empty person in Sharepoint. I also tried to change the empty person field with 'nobody@xxxx.com' but also obtain an error because the email address doesn't exist and connot be found
    So, i don't know how to create the full record also when 1 person field is empty

    Any help ?

  • DGPowerAutomate Profile Picture
    on 14 Jun 2024 at 09:59:11
    Re: Import Excel table to a Sharepoint List

    thanks  SudeepGhatakNZ but i'm not able to apply ... 😞
    I started for scratch and tried to apply only on one field "Site BRM Contact" which can be a multi person/group field but can also be empty
    In Excel each email address are separated by ";"

    DGPowerAutomate_4-1718360003263.png

     


    In our example janus@xxxxxx.com is a valid email address.

    DGPowerAutomate_0-1718359092606.png

     

    So the result is:

    DGPowerAutomate_3-1718359870698.png

     

     

     

    Where am I wrong?



  • SudeepGhatakNZ Profile Picture
    14,292 Most Valuable Professional on 14 Jun 2024 at 00:55:44
    Re: Import Excel table to a Sharepoint List

    @DGPowerAutomate 

    1. You can either copy paste the "null check" logic for all fields by adding multiple conditions "or" use a single expression like 

    @or(empty('Field1'),empty('Field2'),empty('Field3'))

    2. Use the ‘Search for users’ action: This action allows you to search for a user based on their email or ID. You can then use a condition to check if the length of the output array from the ‘Search for users’ action is greater than zero, which means the user exists

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

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,440 Most Valuable Professional

Leaderboard
Loading started