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

(0) Share

Report

Posted on 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

All responses (1)

Answers (0)

DavidMullett 51 on at

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?