Share
Report
21Hi,
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.
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
All responses (
Answers (
