Unanswered

How to select mail values from Apply to Each from Search by user action

(0) Share

Report

Posted on by Palucci12

I have an Apply To each action that is searching and users now

And how to extract only the values from the Mail column? from the Apply to each action ?

I tried compose items('Apply_to_each 3')?['Mail'] but i got error . When i Added to other Apply to each i got empty input . Could you help ?

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Hi @S-Venkadesh, then place a cudo 😉

Was this reply helpful? Yes No
S-Venkadesh 1,176 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @VictorIvanidze , Appreciate your suggestion!

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (1)

Report
Copy link

Link copied!

Hi @S-Venkadesh,
don't be offended, but your suggestion is extremely slow and overcomplicated.
Your "Step 3: Loop Through the Search Results" just useless, as a single Select action replaces the whole loop completely.

Was this reply helpful? Yes No
S-Venkadesh 1,176 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Palucci12 ,
There is an issue with the placement of the action 'Apply to search result' in the flow. To correct this, the action should be placed inside the 'LoopTeamLeader' loop. Please refer my previous screenshot.

I hope this information is helpful. If it is, please consider giving a thumbs up.

Best regards,
Venkadesh Sundaramurthy

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Use this approach:

Was this reply helpful? Yes No
Palucci12 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your replied ! But its not working for me:
This is my settings
Thiss result run a test flow and error . May you know why ?

Was this reply helpful? Yes No
S-Venkadesh 1,176 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Palucci12 ,
let's demonstrate the case of how to select email values from the "Search for users" action in Microsoft Power Automate
Step 1: Loop Through the Search Text
Step 2: Input the Search Text into the "Search for users" Action
Step 3: Loop Through the Search Results
Step 4: Add Email into Array
Refer below screenshots: (Formula added in note section)

I hope this information is helpful. If it is, please consider giving a thumbs up.

Best regards,
Venkadesh Sundaramurthy

Was this reply helpful? Yes No