InfoPath Dev

Description: I have IP 2013 form hosted in SP online, hosted as IP form webpart. The IP form has RUN QUERY section that fetches the data from SP list. The data is displayed in repeating section in the IP form. Each section has a Submit button. Issue: When one section Submit is clicked, the data saves all the listed records in the RUN ...

I have uploaded the form. I use a drop down for what action they would like to take. It is all driven from a list that also updated the Form Status based on the action. Remember this is a dev form so naming is a little off in some places

 So, I'd guess you would want to set the ID field with something like this: xdXDocument:GetDOM("Teams_roster")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[count(current()/../preceding-sibling::my:group2) + 1][d:Dept = XPATH TO YOUR DEPT FIELD]/d:ID With the bold part being the main data source field (or ...

I think there are still some risks, sure - I don't know what all the various logic or buttons you have in your form are. :) Another option may be to push this to the user, in a way. Have a field in the form (not displayed) indicating whether the updated file name has been retrieved & disable "Submit for Approval" until it has. If ...

So I have thought about checking for the name on the second submit but my concern is that the user hits Save and Continue then hits Submit for Approval right after that and duplicate records are created. I am interested in the query for the SharePoint ID on submit if the filename is equal to blank. but what is the risk of overriding or getting the ...

How about if Save & Continue is only possible after the first submit? Then, the form's name is updated, they can re-open from the library and continue on their way? Or, perhaps you check for that file name as the first step on your "Save & Continue" - skip it for new forms that haven't been submitted, but for forms that ...

Yes this library will be used by a lot of people. So to eliminate the chance of it overwriting we first save as UserName + DateTime to the library and that fires off the workflow. The first step of the workflow is to grab the FileType + SharePoint ID created when it was first save with the UserName + SharePoint ID. I have a hidden field with the ...

Can I see your form? You can email it to me if you don't want to post it here...

Got it. So - is this library heavily used? One way to do this is to query the library right before you submit to return the ID numbers & get the max(ID), then use it in the form name. If the library gets a lot of traffic, you run the chance of having someone else get the same ID tho - both query at the same time before the submit is complete.

Hilary, I am having trouble adding the filter as you suggest. I am not sure where to add it. I have 3 rules on a "Set" field that gets the ID in field1=xdXDocument:GetDOM("Teams_roster")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[count(current()/../preceding-sibling::my:group2) + 1]/d:ID, the fullname in ...