web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Scheduled Workflow Bas...

Power Automate

Suggested Answer

Scheduled Workflow Based on Date in a SharePoint List

(0) Share

Report

Report

Posted on by AD-09021938-0

I am trying to create a workflow with power automate that is scheduled to go out on weekdays. When I create the Get items, I want to have the filter query to grab from my sharepoint list for a date column if the date column matches today. After power automate retrieves from the date column and it matches today, I want to apply to each for approval permissions. I can't seem to get the Get items function to work to even test the approval workflow. Can you please assist?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Please share a screen shot of the get items action and how you have it configured (redact any sensitive URLs, etc.). Also, share the filter query that you are using. One of the most common issues I see with filter queries on dates is that people do not format the query using the ISO8601 date format, which is required. See https://learn.microsoft.com/en-us/power-automate/date-time-values#format-date-and-time

Was this reply helpful? Yes No
Suggested answer

Assisted by AI

pankaj3 20 on at

Like
a
(0)

Report
Copy link

Link copied!
1) Create a weekday-only scheduled flow

Trigger: Recurrence

Frequency = Day

Interval = 1

At these hours/minutes = your preferred time like-1,2, 3...

On these days: Mon, Tue, Wed, Thu, Fri

Time zone = your local time zone (e.g., India Standard Time) — this ensures “weekday” is evaluated locally.

Why this matters: Your date comparison will be calculated from this timestamp. If your SharePoint date is interpreted in UTC, we’ll handle that in the filter.

2) Use Get items with a correct OData Filter Query

You have two robust options. Pick the one that matches your SharePoint column configuration.

✅ Option A: If your SharePoint date column is Date only

Use equals with yyyy-MM-dd:

DueDate eq 'formatDateTime(utcNow(), 'yyyy-MM-dd')'

Replace DueDate with your column’s internal name.

This works when the column is truly Date only (no time). SharePoint stores it as midnight UTC, and this comparison matches the date string.

✅ Option B (Most reliable): Handle Date & Time or uncertain time zones

Use a start-of-day to next-day range in UTC:

DueDate ge datetime'formatDateTime(utcNow(), 'yyyy-MM-ddT00:00:00Z')' and DueDate lt datetime'formatDateTime(addDays(utcNow(), 1), 'yyyy-MM-ddT00:00:00Z')'

This grabs everything on “today” between 00:00Z and before 00:00Z next day.

Works even if your column stores time or if some entries have non-midnight times.

3) Apply to each → Approval

Add Apply to each

Select an output from previous steps: value from Get items

Inside the loop, add Start and wait for an approval (or Create an approval + Wait for an approval)

Title: e.g., Approval for items('Apply_to_each')?['Title']

Assigned to: your approver email (could be a person column from the item, e.g., items('Apply_to_each')?['Approver']?['Email'])

Include item fields in the details as needed.

Please accept the answer if it satisfies your requirement.

Was this reply helpful? Yes No

Join the conversation