How do I store a lookup field title rather than ID?

Forms SharePoint Online
1

I am using exiting SharePoint lists to populate several drop downs on a form. It works perfectly until the next morning -- when all the fields using a lookup lists are empty. These SP lookup lists are refreshed (items deleted then repopulated) every morning. I suspect the form is storing the item ID (which changes) rather than the Title (which does not change). Is it possible to select correct key?

2

Hello @tnewton,

Welcome to Plumsail Community!

Yes, the lookup field stores the item ID. You can populate Drop Down field with list values and store the title of the selected item in Single Line Text field. You can find the example in our documentation here.