InfoPath Dev

Excellent - glad you are all squared away. It took me a while to really understand current() in XPath, but it really is the answer to a lot of these "filtering in a repeating group" questions. Have a great day!

Oh thank you so much!!!!! I spent whole day yesterday searching for the solution to my problem... This works like a charm!!!

So - when I changed the filter to select the Vendor field in the main DS, InfoPath used the absolute path to the vendor - which would not have helped the situation at all. :) Instead, I manually changed it to use the current() function. Since the rule is on the Vendor node, which is in a repeating group, current() will always return whatever ...

Hilary you are the best.. Thank you. I have attached the template.

Ok, so this looks like you are comparing the title in the secondary data source to the same field. Change the filter so that Title in spVendors = Title in your main data source....Feel free to attach a copy of your template under the Options tab in a reply if you'd like a hand. :)

You'd need to remove delete permissions in SharePoint. I think you create a new permission level that doesn't include delete, then assign that to your user group instead of the normal "contribute" permission level that includes delete. https://sharepoint.stackexchange.com/questions/232978/disable-delete-item-from-shp-list may ...

Thank you for the quick reply. Here is the full XPath. xdXDocument:GetDOM("spVendors")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Rate[../d:Title = ../d:Title]

Hi- Just a heads up.. I only have SharePoint OTB and InfoPath Designer. I just ran into an issue where someone mistakenly deleted a record from SharePoint in the FORM view. My question is, is there a way to remove the 'Delete' option when someone pulls up the form in SP? Photo Attached

The formula probably needs to use the "current" function.... in the formula editor, can you tick the edit XPath box and then paste in the full XPath in a reply?

I have a form that I am working on. It gets information for a SharePoint list. My list has two columns. One called vendor on called rate. The drop down in my form to select vendor is working well but the rate that is returned regardless of the vendor selected is always the first rate from the SP list. The rule I am using to get the rate ...