Answered

In/Out Board, check if staff is out today or not

(0) Share

Report

Posted on by Aethyta

I have an [Absence Request] list with the following data:

I have an In/Out Board that gets updated daily from the [Staff Directory] list. The [Staff Directory] list contains the employee's work schedule (we have regular, varies, and alternate work week). The Flow I created to update the [In/Out Board] based on the [Staff Directory] seems to work.

Now, I'm trying to create another Flow that will update the same [In/Out Board] based on the [Absence Request] list. If the staff is out today, it should indicate the 'activity' (i.e. Vacation, etc) under Today Schedule and 'Out' under In or Out column.

Below is my flow to check if the [is Staff Out Today]. I appreciate it if someone can tell me if the formula is wrong.

@if(and(lessOrEquals(substring(outputs('Start_Date'),0, 10), utcnow('yyyy-MM-dd')),greaterOrEquals(substring(outputs('End_Date'), 0, 10),utcnow('yyyy-MM-dd'))), 'Yes', 'No')

Because I can't seem to test it using the preview page -- each time I click to check the subsequent item in the APPLY TO EACH, the value doesnt change from the first item

Any help is greatly appreciated. Thanks and have a great weekend.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-monli-msft on at

Like (0)

Report

Hi,

I saw you have another similar post here:

https://powerusers.microsoft.com/t5/General-Flow-Discussion/SharePoint-Get-Items-Filtered-by-Date-Recurrence/m-p/33891

Please check replies there to avoid duplicated threads.

Regards,

Mona

Was this reply helpful? Yes No
Verified answer

Aethyta on at

Like (0)

Report

@v-monli-msft Thanks but that was a different question about Get Item filter query. Not a duplicate. But yes, I could have put both questions into one post. Anyway, I'm marking this answered since its working now. I didn't do anything different except re-created everything. But the GET ITEM filter query is still unanswered.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Use this: https://ivasoft.com/inoutboardflow.shtml

Was this reply helpful? Yes No