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
278
Most Valuable Professional
MS.Ragavendar
146
stampcoin
130