cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RSvensk
Frequent Visitor

Filter out email adresses from a Excel table depending on value in a sharepoint list column and start an approval

I will try to explain what i'm looking for.

  1. An item is created in a sharpoint list, one of the columns has one or more values in it. i.e BLUE, GREEN, RED.
    1. When that item is created a flow will start.
  2. I want the flow to verify if ANY of BLUE, GREEN, RED is present in a Excel table.
    1. And the rows that has one or more of this values, it will collect email adresses on that row.
  3. Put those adresses into the approval step.

Everything after that have solutions for, but i need some help how to manage this first parts.

2 REPLIES 2
krootz
Solution Supplier
Solution Supplier

@RSvensk 

1. From step 1 put the column selected values (BLUE, GREEN, RED) in an array and call it "Array 1"

2. List all rows from your excel, apply to each, collecting any BLUE, GREEN, RED into another array and call it "Array 2"

3. get the distinct list of values from both arrays by using the union() function

4. Count the number of elements resulting from step 3.

5. If count>1 get the email, start the approval process.

6. process the next excel row

RSvensk
Frequent Visitor

Hi @krootz

What Array do you mean? some array from Data Operation or Variable?

Can you show howto?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,237)