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 ?

All responses (7)

Answers (0)

VictorIvanidze 11,859 on at

Like (0)

Report

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

Hi @S-Venkadesh, then place a cudo 😉
S-Venkadesh 636 on at

Like (0)

Report

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

Hi @VictorIvanidze , Appreciate your suggestion!
VictorIvanidze 11,859 on at

Like (1)

Report

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

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.
S-Venkadesh 636 on at

Like (0)

Report

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

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
VictorIvanidze 11,859 on at

Like (0)

Report

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

Use this approach:
Palucci12 on at

Like (0)

Report

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

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 ?
S-Venkadesh 636 on at

Like (0)

Report

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

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