web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sharepoint Date issue ...
Power Automate
Unanswered

Sharepoint Date issue in Flow

(1) ShareShare
ReportReport
Posted on by 1,257 Super User 2024 Season 1

I am using power automate to compare 2 sharepoint lists using 2 pieces of criteria List A and List B

and where they match with both criteria I update one field in List B. It is working no errors

 

The issue I'm having is that one of the fields that is being compared is a date field. It is just a date field not date and time but for some reason when it is pulled into power automate from List A the date changes  So looking at the List A  it could look like 05 June and there is  comparative record in List B for 05 Jun  but when I look at the raw data of the run to see why it didn't update I notice that the date field from List A comes in as 06 Jun in the raw data? so obviously therefore it doesn't match and doesn't update.

 

both lists are in the same sharepoint site with the same regional settings

 

 

 

 

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @vffdd It's hard to offer any recommendations without seeing how your flow is laid out. If you are using the new designer, toggle it off and click each action to expand them.

     

    Upload a screenshot of your flow in edit mode and the error you are receiving, it would help to provide more insight.

     

    In the meantime, you might be interested in this YT Tutorial:

    How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks

    Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate.

     

    I’ll cover some common use cases and concepts that can help you to build better Power Automate flows. Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.

     

    IN THIS VIDEO:

    ✅ 4 Date Functions You Need to Know

    ✅ How to use the Convert Time Zone Action

    ✅ How to Get a Future Date

    ✅ How to Get a Past Date

    ✅ How to Return SharePoint Items Due in a Number of Days

    ✅ How to Return SharePoint Items Due within a Date Range

    ✅ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days

    ✅ How to Calculate the Number of Days between Two Dates

    ✅ How to Check for a Birthdate and Anniversary Date

    ✅ How to work with Dates and Times in Excel

    ✅ How to use a Manual Trigger with Date Input

    ✅ How to Output Dynamic Text with an Expression

    ✅ How to Check if a Date Falls on a Weekend

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution ✅.
    Consider giving me a 👍 if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram
  • vffdd Profile Picture
    1,257 Super User 2024 Season 1 on at

    ok thank you I'll have a look at that but there is no error.   Everything works fine the issue is that the datefield from ListA  changes when it comes into the power automate therefore it doesn't update because it can't find a match, which is the correct action however it should find a match because if the date came in correctly it would !  I just have no idea why when I look at the sharepoint list in sharepoint a record can show as 05 June in the datefield but when I look at the raw data for that item in powerautomate after the get items function it's showing at 06 June...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard