You’re offline. This is a read only version of the page.
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!
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
#1
WarrenBelz
146,731
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,079
Most Valuable Professional
Share
Report
All responses (
Answers (