Skip to main content
Community site session details

Community site session details

Session Id : mpRLIC3jQbZzIFXyWBqTIo
Power Automate - Building Flows
Answered

Create a flow to check each value in an array/list

Like (0) ShareShare
ReportReport
Posted on 16 Jan 2023 21:49:11 by 5

I have a SharePoint list with a "Holiday Name" column and a "Date" column.

I created a variable and gave it a date as its value. It is a string.

I used Get Item on the SharePoint list and put the values into an array.

The values show in the array as key:value pairs, or "Holiday Name":"Date" 

 

I want to make a flow that will take the (string)variable and see if it matches any values(dates) in the array. 

If it is, I want it to subtract 1 from the count_week_days variable.

I need it to loop through and check the date given against all of the values in the array.

 

I'm getting stuck somewhere here. I'm sure it's something silly and simple.

Any help is appreciated. I hope I am being clear here. 

 

My flow is below:

Quality_2023_2-1673905669205.png

 

Quality_2023_1-1673905621170.png

 

Quality_2023_0-1673905314869.png

 

  • Quality_2023 Profile Picture
    5 on 17 Jan 2023 at 14:32:59
    Re: Create a flow to check each value in an array/list

    Thank you, Levi. I used your test and it worked.

  • Verified answer
    v-liwei-msft Profile Picture
    on 17 Jan 2023 at 03:12:20
    Re: Create a flow to check each value in an array/list

    Hi @Quality_2023 

     

    The problem is with the setting of Select.
    I made a test for your reference:

    vliweimsft_0-1673925024359.png

     

    Best Regards,

    Levi

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!