web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Help with Sharepoint a...

Power Automate

Answered

Help with Sharepoint and Date Query

(0) Share

Report

Report

Posted on by glitter1234567

129

Hi All,

I am trying to 'get items' from a SharePoint list where the today's date is 8 days post the SharePoint date.

I have set the following variable

to get my query control. This is working i.e. on the 21/03/2024 its returning 13/03/2024

Then I have a get items from my SharePoint list with the following criteria

This is returning 1 item with a reviewMeetingDate = 12/03/2024. I think this is to do with a timezone issue and Sharepoint storing values as UTC but I can't quite work out how I work around it. I tried 'convert time zone' my varDate8DaysPost to UTC but still returns 13/03/2024 and get items brings back dates of the 12/03/2024

What am I doing wrong, on a side note my date field on my sharepoint list is set as date/time but for my query I don't care about the time just the date.

Thanks

Categories:

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @glitter1234567 ,

You can format utcNow as a date only value then use the variable in filter query:

addDays(utcNow('yyyy-MM-dd'),-8)

Best regards,

Join the conversation