Automatically update SharePoint column with InfoPath function result - InfoPath Dev
in

InfoPath Dev

Automatically update SharePoint column with InfoPath function result

Last post 03-17-2018 05:15 AM by shaunanthony. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 03-16-2018 08:12 AM

    Automatically update SharePoint column with InfoPath function result

    Hi all - debut post! Really hoping someone can help. I have a SharePoint 2013 list, with an associated InfoPath 2013 web form. In this web form, some of the fields have a function embedded into them to lookup data from a separate list, which is also filtered. This works fine in InfoPath, however it doesn't automatically write this value to the SharePoint column the field is based on when the external data (in the separate list) is changed. So in other words, when the user opens the form the data is always correct and up-to-date as InfoPath is live-reading the data. However to reflect this in the SharePoint list, the item needs to be opened and saved. Is there a way to automatically update the SharePoint list with the latest function results? Thanks
  • 03-16-2018 08:14 AM In reply to

    Re: Automatically update SharePoint column with InfoPath function result

    Sounds like something that you should use a workflow for - you need a Flow (if Office 365) or SharePoint Designer workflow on your separate list, so when items change there you can go update the list you are wanting to keep in synch. InfoPath rules only run when the form is used, of course, and if the user doesn't save the data, the list won't be updated. :)
    Hilary Stoupa

  • 03-17-2018 05:15 AM In reply to

    Re: Automatically update SharePoint column with InfoPath function result

    Hey thank you - that seemed to do the trick!
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.