InfoPath Dev

Hello, I am stuck in a very annoying problem right now. I am trying to somehow create a new folder when a new item is created. Here is my scenario. I have a info path form with repeating section and tables. It is a grocery list per say. In my form I add all the information and when I save it to share point it saves every item as its own form. ...

I'll go ahead and add a syntax sample for gt (greater than) - ListName replaced with your list name, and this is comparing the Modified date: /_vti_bin/listdata.svc/ListName?$filter=Modified gt datetime'YYYY-MM-DDT12:00:00Z'

You'll probably need to use the older version - you can see if the ListData.svc is available with this URL (put in your server name, including site collection if needed in place of "myserver"): http://myserver/_vti_bin/ListData.svc

 I am not using SharePoint Online, using SP2016.  I'm not sure how to use REST.

I'm sorry, I'm an idiot - I forgot that we can't query on calculated fields. Yuck. Any chance you can use REST here? Is this SharePoint Online?

 I have created a calculated column with the formula =IF([Created]>=(TODAY()-7),"Yes","No") and this sets the field to Yes on all records created in the last 7 days.  I've added the new column in my data connection but it is not showing up in the query fields section of the data connection.  Any thoughts?

So - the issue is with our query fields in InfoPath data connections, we can only use equivalence. You won't be able to check if something is less than today minus 7 for example. If you are using on-prem you might be able to use a REST query for this, using the listdata.svc. I'm trying to think of an approach that can use a regular list ...

I have a SP2016 list that has now reached 5000 items or its search limit.  My form can longer query the data connection to get the highest ID value I use to increment my records.  I have been told I need to create a subset data connection that doesn't query the entire list but rather records created more ...

It sounds like you have a good implementation that meets your end goal - working around the limitations of InfoPath. :)

Yes, that's correct. The user would fill out a review for each category and each category can have multiple reviews. I ended up implementing a solution in which I show them how many categories are allowed for the type of review they are doing and make sure they do each of them. I've got a repeating table that holds reviews and a drop ...