1

I created a list with a choice column. Let's call this list List A. I modified the form through InfoPath and set it up so that the choice options are connected to another SharePoint list (List B). Changing list items in List B updated the choice column options in List A.

Now the problem is that as the choice column options are updated via List B, previously checked off options in List A that are not in List B anymore are still visible. I'd like them to disappear as List B is changed as that data in List A is irrelevant at that point. I am mainly afraid that I could run into size limit issues with dozens of checked off choice items and growing without an easy way to purge the data.

Does anyone have any suggestions?

Thanks!

1

I recommend you using OOB Lookup column to get the information from List B in List A. Lookup column can also get the options from another list and user can select the relevant options.

Lookup column in List A will automatically update if there is any update for column in List B.

  • It worked!!! Thank you so much. You saved me hours of fiddling with the options. And I was able to keep my InfoPath form! – Marin Jan 31 at 17:41
  • I'm glad the reply helps you, you can mark it as answer. Thanks for your understanding. – Hellofiona_MSFT Feb 5 at 6:41

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.