Checking between two dates if they match a sharepoint list array.

Like (0) Share

Report

Posted on 7 Oct 2021 14:52:44 by DavidMullett

Hi,

Apologies the subject header might not make much sense as it stands. Basically I'm running a system which requires it to calcuate how many work days there are between two dates in a SP List. That's all fine, I've got a StartDate / EndDate / DaysExWE which is calculated column which strips out the weekends. However what I need to do is make sure none of those days fall on a bank holiday.

I was going to have a separate SP List but I'm stuck with the logic of how I would do an array in power automate presumably with a 'Do Until' loop. And when I mean stuck with the logic, I don't even know where to start!

Thanks

David

I have the same question (0)

All responses (1)

Answers (0)

DavidMullett 51 on 11 Oct 2021 at 15:07:57

Like (0)

Report

Re: Checking between two dates if they match a sharepoint list array.

So I've added a new SP List and Parsed JSON from a website to pull in basically a list of dates. Would I do a compose in Power Automate and pull in all the list items?

Was this reply helpful? Yes No