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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Compare two sharepoint...
Power Automate
Unanswered

Compare two sharepoint lists with date fields to see if a specific date exists in both fields

(0) ShareShare
ReportReport
Posted on by 21

Hi, 

I need help with this flow that I am building. I have two SharePoint Lists (see below):

(a) Equipment Balance - shows the  capacity of the equipment by Dates

(b) Equipment Loan List - shows the list of booking of equipment by Dates. 

Bee1_3-1656664769542.png

Bee1_2-1656664727564.png

 

 

 

When a booking request for a specific booking date(e.g. 1 July 2022) and time of booking (e.g., half day or full day) is received,  the flow is expected to do the following:

(a) Check if there is already an SharePoint item created in Capacity List for the specific booking date. 

(b) If no, Flow is to create the SharePoint item in the Capacity List and update the balance field in the list based on the request

(c) If yes, Flow is to update the balance field in the list based on the request. 

 

I don't think the use of simple condition statement of checking the specific booking date with date in Capacity List will help as in most cases, the dates were end up not matching, resulting in many new SharePoint items being created. As my knowledge of Flow is quite limited, would appreciate any help from community. 

 

Thanks in advance

 

Bee1

 

 

Categories:
I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

Last 30 days Overall leaderboard