Answered

Flow

(0) Share

Report

Posted on by yllikrs

Hello, I want to make a flow that sends an email to Manager when the Contract of the employee is due date (I want to send it 10 days before but don't count weekends), To delay Saturday and Sunday. Also it needs to work with filter query(asked from my boss)

Screenshot 2022-07-26 094747.png

The error is in switch( Case1 and Case2)

Categories:

General topics

All responses (3)

Answers (1)

Sort by

RobElliott 10,539 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

What is the expression in your ffirst compose? You will need to use a dayOfWeek expression, for example

dayOfWeek(utcNow()) and it doesn't look as though you've used that.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
yllikrs 68 on at

Like
a
(0)

Report
Copy link

Link copied!

Now the error is here.
At the format I Think.
Should I just do utcNow or what.
And also can you help me with the filter query in GetItems? I need to use that aswell.
It needs to lookup all of the rows in sharepoint but only filter the ones that are due date
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@yllikrs Pls take help from here- SharePoint Get Items and Filter Query in Flow [Part-3]. | Gopenly

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in