Answered

power apps lookup field limit

(0) Share

Report

Posted on by WhoRU87

Has anyone figured out a way to limit a sharepoint date source to a given view? If so, can someone share the filtering syntax? My list/form is very complex and has significantly north of 12 lookups.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Vijay Tailor 2,961 on at

Like (1)

Report
Copy link

Link copied!
Hi @WhoRU87 ,

You can Filter Out the Data that you want to Show.

Like below -
Filter(SplIst,ColumnName=Value); if you want to Display Only Distinct Value then Distinct(Source,ColumnName).Result

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @WhoRU87 ,

Are you encountering the “exceed the lookup column threshold” error? Do you want to use a SP list view to be the data source?

If you do, I’m afraid it is not available in Power Apps for now.

If you would like this feature to be added, you may vote for the idea below in Power Apps Idea Forum:
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/View-in-PowerApps-based-on-sharepoint-list-view/idi-p/168766#comments

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No