cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How to get items of approvers emails and exclude requester if he is an approver!

Hi,

how to get items of approvers from sharepoint and how to exclude the requester if he is one of these managers by doing filters.

I already have from Scott eariler if we use variable but by get item and make filter and condition will make it easier.

 

Waleed.

1 REPLY 1
Highlighted
Responsive Resident
Responsive Resident

Re: How to get items of approvers emails and exclude requester if he is an approver!

@WK-PA2020 

 

Please provide more details. if i understand your problem correct these steps may help you-

1. Apply filter query - like Status eq 'Approved' in Get Items.

2. Use select action- Store all approvers in this array from get items.

3. Use compose action- Input: Created by.(Here you will store requestor)

5. Use condition action under apply to each action- (loop values: body of select action)

6. For each false condition append your approvers in "Append to String/Array variable". (please initialize array/string variable before using this step)

7. Now your variable contains all Approvers except requestor.

 

Thanks

Hardesh

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,364)