Unanswered

Import Excel table to a Sharepoint List

Like (0) Share

Report

Posted on 13 Jun 2024 12:35:02 by DGPowerAutomate

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?

Thank you a lot in advance for your help

All responses (5)

Answers (0)

DGPowerAutomate on 18 Jun 2024 at 06:40:27

Like (0)

Report

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 14,292 Most Valuable Professional on 15 Jun 2024 at 23:28:10

Like (0)

Report
Re: Import Excel table to a Sharepoint List

Try this

if(empty('Person Field',null,'Person Field')
DGPowerAutomate on 15 Jun 2024 at 10:22:53

Like (0)

Report

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 on 14 Jun 2024 at 09:59:11

Like (0)

Report

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 ";"

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

So the result is:

Where am I wrong?
SudeepGhatakNZ 14,292 Most Valuable Professional on 14 Jun 2024 at 00:55:44

Like (0)

Report
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