Skip to main content

Notifications

Community site session details
Power Apps - Building Power Apps
Answered

Best recommendation for Lookup in SharePoint vs Lookup in PowerApps

Like (0) ShareShare
ReportReport
Posted on 3 Mar 2024 13:09:55 by 948

I'm looking for recommendations for the experts (because I am not one).  I am working on an Onboarding / Employee List / Offboarding.  I currently have those 3 list.  The process would start with creating the Onboarding for the new employee (with some fields that will be filled out and used across the 3 lists).  My thought was, once the Onboarding is created, it will then create an item in the Employee List and populated the related fields and make the employee Active in the Employee List.  Once the employee is no longer active, their status would be marked as Inactive, which would then create an Offboarding item and send out email for tasks to be completed.  My question is, should I use lookups within the SharePoint List or Lookups in the PowerApps customized form (which I'm currently using).  Should I keep it the way it is using SharePoint customized PowerApps with Flow or create a Canvas App and still use Flow for notifications?

 

Thank you very much for any feedback from this awesome community!

  • Verified answer
    WarrenBelz Profile Picture
    147,207 Most Valuable Professional on 03 Mar 2024 at 20:31:13
    Re: Best recommendation for Lookup in SharePoint vs Lookup in PowerApps

    Hi @kmw1130 ,

    Lookup columns in SharePoint are generally unnecessary and at times can create unwanted complexity and limitations in Power Apps. SharePoint is not a relational database when used as a data source of Power Apps and you can access the looked up list field in Power Apps by simply doing it directly to that list/field. I do not use them at all and use Power Apps lookups when necessary.

     

    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.

    MVP (Business Applications)   Visit my blog Practical Power Apps

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

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

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 274 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 142

#3
stampcoin Profile Picture

stampcoin 123

Overall leaderboard
Loading started
Loading started
Loading complete