Unanswered

Check if holiday date matches with today date & send Email.

(0) Share

Report

Posted on by Eswar1

Dear Team Members,

1) I have a Sharepoint list in which leave start day and leave end end date of Leave are applied, I want to check if todays date matches and then send a email to my manager with list of all employee names.

Logic Used :

Now() >= StartDate & Now() <= Date

Flow Steps:

Prsentday values:

Checking the following condition : Now() >= UserStartDateTime & Now() <= UserEndDateTime

WhatsApp Image 2021-01-22 at 3.40.49 PM.jpeg

Getting an error with the filter query when executing:

Checked my Json value as well :

Both the column values are of type strings.

Can you please help me with the completion of the flow and were I am going wrong in the query.

Thank you very much,

Eswar T

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

Eswar1 60 on at

Like (0)

Report
Copy link

Link copied!

I have tried changing the format the dates value to yyyy-mm-dd as suggested.
Now i get the present day value to be a day before :

Again I tried to revert back the code to dd-mm-yyyy in this case i get the present date (2/2/2021).

But in both cases the output of filter of get Items shows values that are of previous years:

Kindly suggest.

Thanks,
Eswar T

Was this reply helpful? Yes No
jdoss 458 on at

Like (0)

Report
Copy link

Link copied!

You may need to try to format the dates as 'yyyy-mm-dd'
See this post: Solved: Filter query between date - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
Eswar1 60 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for the reply, I am able to get the flow running but I am not getting the correct values.

Query:

The query has returned the results that are for previous years as well.

Results:

Thanks,
Eswar

Was this reply helpful? Yes No
jdoss 458 on at

Like (0)

Report
Copy link

Link copied!

I see the problem now. Your filter query isn't formatted correctly. The trigger body would be a recurrence which doesn't have a 'FirstDayOfLeave'.
It needs to be in the format ColumnName ge PresentDate and ColumnName2 le PresentDate.
See this other thread: https://powerusers.microsoft.com/t5/Building-Flows/FLOW-Get-Items-Filter-SharePoint-list-on-Date/td-p/85238

Was this reply helpful? Yes No
Eswar1 60 on at

Like (0)

Report
Copy link

Link copied!

Dear jdoss,

I have added the first day into variables and this is the error I am getting.

Thanks.

Was this reply helpful? Yes No
jdoss 458 on at

Like (0)

Report
Copy link

Link copied!

Add the formatted first day of leave and formatted last day of leave into variables as well and see what is returning there.

Was this reply helpful? Yes No