Announcements
Hi!I have to ask, is there a way to use lookupcolumns and relationships in sharepoint without getting stuck with delegation problems?
In this case Im trying to filter on a lookup column "CustEntity:Kundansvarig" and I dont see how to do it whitout getting delegation problems?Is there a way around it?
@adamtj
Yep, don't use lookup columns in SharePoint. Create the relationship manually. See https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Relational-Database-Principles-and-PowerApps-Step-3-Keys-and/ba-p/188640
@Drrickryp thank you, yeah i figured that after experimenting for a while. Shame thou its nice to have some backend relationship action going on.
We can now filter on lookup columns & related fields while avoiding delegation limits using this set up: https://powerusers.microsoft.com/t5/Community-App-Samples/No-Delegation-Limit-SharePoint-List-Power-App/td-p/2330721
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 354 Super User 2026 Season 2
M Bilal Khan 330
Mohsin Ali 232
