web
You’re offline. This is a read only version of the page.
close
Skip to main content
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

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 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard