Add ID from SharePoint to Form - InfoPath Dev
in

InfoPath Dev

Add ID from SharePoint to Form

Last post 09-22-2016 12:58 PM by Ruenells. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next
  • 09-22-2016 07:59 AM

    Add ID from SharePoint to Form

    I need to add the ID to a form to display after the item has been created. I am having a hard time finding a way to do this and all of the articles I have found are very old. Can someone direct me to the correct location or help me get this figured out. Happy to provide screenshots and what I have completed so far. Thanks Dorinda
  • 09-22-2016 08:15 AM In reply to

    Re: Add ID from SharePoint to Form

    Here's what we usually do - add a field to the form that has a unique id of some kind - like user name and now(), for example - set the field on form load if it is blank, that way you know you have a stable, unique ID. Promote that field to the form library. Add a query to the library that includes this new column and the ID column - don't run on load. Then, when you submit the form, you can set the query field to the unique ID in this secondary question, and then run the query to get the ID back....
    Hilary Stoupa

  • 09-22-2016 08:21 AM In reply to

    Re: Add ID from SharePoint to Form

    So there is already a field on the form with that information can i use that? I am not sure I am following the second piece of this. Sorry very rusty in InfoPath and really appreciate the help.
  • 09-22-2016 08:23 AM In reply to

    Re: Add ID from SharePoint to Form

    I'm not sure what you mean. Can you attach a screenshot or your form under the options tab in a reply?
    Hilary Stoupa

  • 09-22-2016 08:33 AM In reply to

    I have attached all of the screenshots. Hope this helps
  • 09-22-2016 12:48 PM In reply to

    Re: Add ID from SharePoint to Form

    Just wanted to recap the resolution - since you only needed to see the ID when a previously submitted form was re-opened, you added a data connection to the library the form submits to, set it to return data for the active form, and added a form load rule to set your main data source "ID" field from the secondary data source ID field.
    Hilary Stoupa

  • 09-22-2016 12:58 PM In reply to

    Re: Add ID from SharePoint to Form

    Thank you so much for walking me through all of this and it worked like a charm!!
Page 1 of 1 (7 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.