Hi,
Using lookup on a column to pull in names for our app when an item is assigned. The main list of names gets updated every week, we noticed that the names are changing for the assigned when names are added or removed. Anyone know how to prevent this?
Thanks
Hi @jneuen ,
One of the perils of lookup columns (which I do not use) is that the "reference" is actually the ID of the record in the other list being looked up. If you start changing or removing names from the list. it will affect existing records. I suggest you do the lookup in Power Apps and simply use Text columns.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
WarrenBelz
146,763
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional