Hi @BPIT , thank you for posting in the Q&A forum. I would like to confirm a few things with you:
- How is the volunteer record list populated monthly, are you using a flow or other method?
- How do you update the lookup columns automatically for other columns in the volunteer availability list? Are you using workflow/flow to update the lookup columns, or are you referring to the additional fields of the lookup column?
As far as I know, when you create a lookup column, it does not auto-populate itself unless you use other tools to give values to it.
Or if you are using additional fields for lookup columns, they will automatically fill the corresponding fields with the values from the source list. The additional fields show as Read-Only in the target list.
Please see the reference here: Create list relationships by using unique and lookup columns.
If an Answer is helpful, please click "Accept Answer" and upvote it.
**Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. **