Skip to main content

Notifications

Community site session details

Community site session details

Session Id : ZcGZ1PLkVesMW31QCcF8Qo
Power Apps - Building Power Apps
Unanswered

SharePoint LookUp column for Names

Like (0) ShareShare
ReportReport
Posted on 23 Nov 2022 20:11:28 by 55

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

 

Categories:
  • WarrenBelz Profile Picture
    146,763 Most Valuable Professional on 23 Nov 2022 at 20:50:15
    Re: SharePoint LookUp column for Names

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,763 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Loading started
Loading complete