-
When you say you removed & re-added the column - do you mean in the list itself? Or just in the form? When you say opening the form in InfoPath filler, do you mean previewing the form? I'm a little confused because you mention its a list form. :-)
-
I think you are saying the form is behaving differently in the browser than in preview. That can be hard to debug - but it could be in the browser the ID is being returned with decimal places and that's why you aren't getting a match on your XPath filter. Drag the secondary data source onto the form so you can see the actual value in the ...
-
So - I'm confused. You say when it is published - so the form is behaving differently in preview vs. the browser? Or am I misunderstanding? Can you attach a screenshot under the options tab in a reply to clarify?
-
Ok - so you probably have access to MS Flow. I'd start there - it is much more flexible and powerful than SharePoint Workflow Designer.
-
Wonderful! Glad you have it working. :-)
-
Great job, glad I could help!
-
Looks like you aren't filtering the data in your sum function. You are hiding rows on the form, but the data is still present in the secondary data connection. The sum function needs to have the field filtered in the same way as you are filtering your repeating table. You may want to change that total_inspected field to a decimal, so you ...
-
So - can you attach a copy of your form under the Options tab? I can take a look.
-
I think that would likely be simplest.... I've not done this w/ SharePoint workflow, but I'd think MS Flow would make quick work of it. Are you using an On-Prem SharePoint server? Or Office 365 / SharePoint online?
-
I think the challenge here is going to be creating the rules in such a way that you don't end up with an error about rules looping. Instead of allowing multiple people to be selected in the person / group picker, I'd probably put the person / group picker in a repeating section, so each section only had one person, then I'd add a field ...