https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/125466.aspxMon, 05 Feb 2024 13:04:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125466LaceM0https://www.infopathdev.com:443/forums/thread/125466.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=125466Thank you! I am using SharePoint Online, but the version I am using does not utilize Power Apps. I will have to look at other methods - maybe move the running total to the list my form saves too and until then I will do it manuallyhttps://www.infopathdev.com:443/forums/thread/125465.aspxThu, 01 Feb 2024 20:36:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125465Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125465.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=125465Unfortunately, InfoPath doesn't support updating secondary data sources out of the box. There are techniques for doing this - much depends on whether you are using SharePoint on-prem or online. There are also third party tools (my company makes some) that can do this. If you are using SharePoint on-prem I can point you to some instructions for doing this using SharePoint SOAP web services. If you are using SharePoint Online, you might be able to use Power Automate for this - you can read the XML in Power Automate and then use that data to update your other list.https://www.infopathdev.com:443/forums/thread/125464.aspxThu, 01 Feb 2024 18:18:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125464LaceM0https://www.infopathdev.com:443/forums/thread/125464.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=125464Banging Head against the wall.... I have an InfoPath 2013 Form that customers request supplies from that saves to a SharePoint list. The form has a repeating table that is linked to a secondary data source (SharePoint List) that contains an inventory of supplies The customer selects a "Nomenclature" from a dropdown list (secondary data source) their selection inputs a default value of 3 repeating table fields (items ID #),(Cost), (UOM). The customer then inputs the quantity they are requesting of that item. When they submit the form it is sent for approval - once approved I would like to subtract the quantity requested of each Items ID# from the secondary data sources quantity on hand field. Is this a rule I can add to the "Approved Button" if so a little guidance would be greatly appreciated, been working with so many formulas and rules that Im feeling stumped. Thank you