Search for Users (V2) into a SharePoint List

Like (0) Share

Report

Posted on 7 Jul 2022 00:48:42 by cchan-ambc

Hi all,

I am trying to create a flow to pull all phone numbers and names of users using "Search for users (V2)" and populating a SharePoint list with relevant information. However when I run the flow, nothing is populating in the SharePoint list. Not sure what's going on?

I have the same question (0)

All responses (9)

Answers (0)

WijkagentBraum 31 on 08 Feb 2023 at 15:26:55

Like (0)

Report

Re: Search for Users (V2) into a SharePoint List

Allow multiple inputs in your phone column? It seems that in your data it is possible to have more than one phone listed per user. Adding the phone number to the sharepoint list creates a for each to let it run for every phone number. If you allow mulptiple inputs in that column it will simply populate the column with multiple values

Was this reply helpful? Yes No
AnthonyPSlalom 77 on 21 Nov 2022 at 16:52:28

Like (0)

Report

Re: Search for Users (V2) into a SharePoint List

If you just want to insert the FIRST item from Business Phones you should be able to use an expression like
items('Apply_to_each')?['Business Phones'][0]

Was this reply helpful? Yes No
SAIL 4 on 26 Oct 2022 at 05:17:24

Like (0)

Report

Re: Search for Users (V2) into a SharePoint List

the problem is that "Business Phones" is an array of phone numbers unlike "Telephone Number" which is a single value. You're supposed to add code to select a business phone item - I'm having the same problem, but I don't know how to solve it.

Was this reply helpful? Yes No
cchan-ambc 5 on 08 Jul 2022 at 14:58:09

Like (0)

Report

Re: Search for Users (V2) into a SharePoint List

Yes, it is very strange because the flow previously ran ( I must've had the steps in a different order or way). I'm not sure how to get the phone numbers to populate now. Do you think the output should be something else other than "value"?

Was this reply helpful? Yes No
Mira Ghaly 11,409 Moderator on 07 Jul 2022 at 22:06:55

Like (1)

Report

Re: Search for Users (V2) into a SharePoint List

@cchan-ambc

I have tried the same but it did not insert another apply to each, which is weird as well since business hones is a list but I believe it is at least in your case it should be adding more than one record for the same user not just not adding anything

Was this reply helpful? Yes No
cchan-ambc 5 on 07 Jul 2022 at 02:19:12

Like (0)

Report

Re: Search for Users (V2) into a SharePoint List

My flow runs properly when I have it like this:

However, when I put "business phones" into the "Business Phone" field, it automatically recreates another "Apply to each" like this and the list doesn't populate.
@Mira_Ghaly

Was this reply helpful? Yes No
Mira Ghaly 11,409 Moderator on 07 Jul 2022 at 01:28:08

Like (0)

Report

Re: Search for Users (V2) into a SharePoint List

@cchan-ambc

I have made a test on my side and it is working as expected

Was this reply helpful? Yes No
Mira Ghaly 11,409 Moderator on 07 Jul 2022 at 01:19:29

Like (0)

Report

Re: Search for Users (V2) into a SharePoint List

@cchan-ambc

Also please share your flow run history!

Was this reply helpful? Yes No
Mira Ghaly 11,409 Moderator on 07 Jul 2022 at 01:18:11

Like (0)

Report

Re: Search for Users (V2) into a SharePoint List

@cchan-ambc

Most Probable the search users v2 is not returning any values and I am not sure why you are having to Apply_to_each actions inside each other, can you please share your whole flow?

Also to try on my side what is the search filter you are using..

Was this reply helpful? Yes No