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:
Thank you, Levi. I used your test and it worked.
The problem is with the setting of Select.
I made a test for your reference:
Best Regards,
Levi