I'm attempting to query against a SharePoint list to see if a person has submitted an item already between two dates. And existing line item example: smith, bob 2/10/20*personal details removed*/14/2020
SharePoint list: User (Person) / Start Date (Date) / End Date (Date)
I want this to fire on a calendar is changed. When I fire the Get List I am attempting to allow for the input of the User and a Filter to check for Dates. When I put more than one date in this filter fails.
Has anyone attempted a query like this?
I'm just looking to see: When a new form is attempting to be submitted to see if the user has a line item already on the list. I'm trying to do a Get List, passing in the User as a parameter then Filtering on Dates. I'm guessing I need to do something a bit more extreme like returning the List ID or performing a Lookup.