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!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,946)