DavidThadAerne

Query against a SharePoint List to see if a person has submitted an item between dates

Community,

 

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.

Get List

8543i1CDC55A36A898C2A.png
0 Kudos
Reply
2 Replies
DavidThadAerne

Re: Query against a SharePoint List to see if a person has submitted an item between dates

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.

0 Kudos
Reply
Nik1
Novice

Re: Query against a SharePoint List to see if a person has submitted an item between dates

Do you get the same result if you execute the same method/filter from SmartObject Service Tester tool?

0 Kudos
Reply