Qdabra qRules

Re: Prevent empty values from saving to a SharePoint List using qrules

RajInfoDev — Thu, 27 Mar 2014 14:23:07 GMT

Unfortunately I wouldn't be able to share the form with you as it contains some confidential information.

All rows in the list have an item ID. I don't have any problems with update or refresh of data.

I am specifically having problems when a default(first) row of a repeating table is deleted on the form, but not from the associated SharePoint list, although its mapped using QRules. Deletion of second, third etc... works. Problem is only with the first default row. The record remains in the SharePoint list. Is this a bug with QRules?

Yes, I have the full version of QRules.

Can you help? Thanks.

Update: For anyone else who has a similar problem, I resolved this by recreating the qrules mappings for all the Sharepoint lists using the InfoPath filler. Now, deletes are going through without any problem. Mel's validation solution above also works. Thanks.

Re: Prevent empty values from saving to a SharePoint List using qrules

Mel Clemente — Wed, 26 Mar 2014 10:31:37 GMT

In order for qRules to know which item to update/refresh in your SharPoint list, it needs to know the list item ID. So you'd want to make sure that your rows have the corresponding ShP list ID.

Are you using a full version of qRules (not relevant but just wanted to know)? Can you attach your form here so I can take a quick look?

Re: Prevent empty values from saving to a SharePoint List using qrules

RajInfoDev — Mon, 24 Mar 2014 12:43:30 GMT

Thank you Mel. The second approach is exactly what I wanted.

Update: I tried the solution from Mel above and it works.

But, the problem is that if there is only row in the repeating table and, if its deleted & the form is saved, qRules doesn't delete the corresponding row from the SharePoint list. If there is more than 1 row, deleting a row in the form deletes the row from the list as well.

I have RefreshSharePointListItems rule for the form.

Re: Prevent empty values from saving to a SharePoint List using qrules

Mel Clemente — Mon, 24 Mar 2014 03:39:58 GMT

Hi Raj,

You can do this in two ways:

Before submit, delete empty rows in your second repeating table, i.e. rows whose dropdown fields are blank. You would use the qRules Delete command - here's an example of a command syntax: Delete /xpath=/my:myFields/my:Group2/my:RepeatingGroup2[my:Dropdown = ""]
Add a conditional expression in your mapping - you'd use the opposite of the condition above, i.e. map only rows whose dropdown fields are not blank, e.g. /my:myFields/my:Group2/my:RepeatingGroup2[my:Dropdown != ""] If you're using the InfoPath to SharePoint List Tool to create your mapping file, the conditional expression goes in the textbox underneath the "Data is from a repeating group" check box.

Hope that makes sense. Let me know if you need more details.

Regards,

Prevent empty values from saving to a SharePoint List using qrules

RajInfoDev — Fri, 21 Mar 2014 18:54:04 GMT

I have configured the qrules mapping for a simple InfoPath form to 2 SharePoint lists.

I have 2 repeating tables on the form mapped to 2 separate SP lists using qrules. It saves form data correctly for the first mandatory repeating table to the first list.

The second repeating table is optional and has no values by default for its dropdowns.

But, when I click save, qrules saves the empty dropdown selection as an empty row in the second SharePoint list. How can I prevent this from happening?

The dropdown data is from data connections so default values cannot be set.

Any help is much appreciated. Thanks.