InfoPath Dev

 Hello,

 can we use the Copy to SharePointList with validation? Example it will only write/update to the list if the status is Submitted 

 

Thanks 

The submit to SharePoint List command will fail if the form doesn't pass validation. However, I think you may be asking instead if you can conditionally submit items? You can add an XPath filter to the repeating group in the mapping file to conditionally submit some of the items.

 Hello, Thank you

 Example I have a repeating section for Logs, in first submission I created 2 entries - then got approved. So status for these 2 entries/lines are Approved

  

 I wanted to add another log, how can I add the filter to say just update this line (to Submitted status)

 My experience was, it updates all the entries back to what the status of the latest entry which should not be the case since the initial 2 entries were approved already.

 Also I don't want set of buttons per section (Submit, Verify, Decline), if I can make this work using 1 button for the entire form using the filter.

Hope it makes sense to you :) Thank you

I'm having a little trouble understanding, I'm sorry. I think you saying you want to update just some of the repeating rows in your table with a button outside of your table? If so, SetValue command can do that - then you can continue to submit all rows to SharePoint.

 Hello, I wanted to share the actual Form, how can I attach? :)

Under the Options tab in a reply. :)

 Apologies to confuse you. How can I update a certain rows of the repeating section using the outside button? how can I add the filter

ex. only items 1 & 2 (out of 5) need to be updated then submit to sharepoint list  

 Thank you - attached :)

 Goal is to get rid of the buttons within the Activity Log section and just utilize the outside buttons (Submit, Verify, Decline)

Scenario

First submission I have 2 activity logs with the other form details (but I wanted to focus more on activity logs section as it needs to be displayed in dashboard via the sharepoint list being created) - then I got them approved

I access the Forrm again and tried to edit and re-submit: I added additional activity log

The initial 2 activity logs should have Approved status (as these have been approved already in the first round of submission) and the recent activity log being added should have a Submitted status

How can I incorporate the Filter in the outside buttons to just copy/update only the 3rd activity log using the Command? 

Thank you. 

  

So - silly question.... but if there are two log items approved and another new item added, if the user clicks an "approve" button not associated with individual items, how do they know what they have approved? Is it just generally accepted it would apply to all that are not currently approved? Or if two are approved and one is submitted, and I now click a "decline" button not associated with individual items, how would I know that I'm only applying that action to the submitted item? What if my intent is to now decline all the items? How would I do that?

However, to answer your actual question - if the Log this Activity button was outside of the section, I'd use a qRules command to just set the rows with a blank status like this:

SetValue /xpath=/my:myFields/my:ActivityLog/my:group11[my:ALStatus = ""]/my:ALStatus /value=Submitted

I'd probably set the other fields first, so I could leverage the blank status as an indicator of what to set:

 concat("SetValue /xpath=/my:myFields/my:ActivityLog/my:group11[my:ALStatus = '']/my:ALSubmitDate /value=", today())

Then, it doesn't matter if all the items resubmit to the list, because the existing items won't have been changed.

 Thank you so much for this.

 How can I set a Date field to date today() - can I have a sample SetValue rule (ALSubmitDate) ? 

 How about setting a repeating section field with an outside section field's value - how can I do that, what command shall I use? 

So - I gave you a sample with "today" - you can see in the concat statement, today is outside the quotes. Put the qRules execution history on your form and you'll see the actual command that was executed with the value of today's date. The same approach works for any field - instead of the today function, you can use the field selector to pick the field with the value you want. All that matters to qRules is the actual string value passed into the Command node.