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

  • 16 February 2020
  • 2 replies
  • 13 views

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

11015iD63512DD1E0E170A.png

2 replies

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.

Badge +9

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

Reply