Check if a user's phone belongs to a sharepoint list

[ThD7]

Hi,

I'm trying to extract data from an excel table (name and phone number). I then want to check one by one every phone number on the excel to determine whether or not by database contains the person.

The issue is that my -For Each [phone from excel], If [phone list] contains [phone from excel]- sentence only return false. See below.

Any suggestion ? (Using Powerautomate in french language)

[v-liwei-msft · Accepted solution]

Hi @ThD7 

I have made a test for your reference:

1.

2.

Use the length function on the Filter array result.
If the result is equal to 0, it proves that the phone number of the item in Excel is not in SharePoint.
If the result is not equal to 0, it proves that the phone number of the item in Excel is in SharePoint.

Best Regards,

Levi

[ThD7]

Thanks a lot.

It seems to work perfectly, I just have one last issue.

In my excel, phone number are saved this way : "XXXXXX", but in my sharepoint list they are saved like this : "XX XX XX", with spaces.

I wanted to use the replace() function to remove the gaps but it doesn't seems to want to accept things from get item from sharepoint in the replace function. 

Any Idea?

[v-liwei-msft]

Hi @ThD7 

The Trim function can be used to eliminate spaces between characters.

I think this link will help you:

Usage Of Trim Function In Power Automate (c-sharpcorner.com)

Best Regards,

Levi 

[ThD7]

Thanks for your answer. Unfortunately, the trim function doesn’t seems to work with get items from sharepoint, as well as replace(). It can only takes value or body parameter as input. 

[Chriddle]

Since trim function is used to remove whitepace from the beginning and the end of a string, it won't help here.

Replace is the way to go!

Both functions accept strings. If your phone number is a string, you can do replacements in it.

[ThD7]

I agree that it should work, the issue is that I can’t figure out how to pass any result from my “get items from sharepoint” action. It doesn’t allows me to select my “phone” column as a parameter, only “body” or “value”.

[Chriddle]

You can check if this is only a flaw in the web frontend of Power Automate.

Does it work to retrieve the phone value of the first entry?

Enter this as an expression into a compose action (immediately after the "Get items"):

outputs('Get_items')?['body/value'][0]['phone']

[ThD7]

Thanks for helping me, it worked.

How may I continue now?

[Chriddle · Accepted solution]

You can use an "Apply to each" with this input expression

outputs('Get_items')?['body/value']

and access the phone values within this loop with this expression

item()['phone']

[ThD7]

It works perfectly, thanks!!