Answered

power apps lookup field limit

Like (0) Share

Report

Posted on 8 Oct 2020 21:03:35 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.

All responses (2)

Answers (1)

Verified answer

v-jefferni on 09 Oct 2020 at 06:50:23

Like (1)

Report

Re: power apps lookup field limit

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.
Vijay Tailor 2,961 on 08 Oct 2020 at 21:24:41

Like (1)

Report
Re: power apps lookup field limit

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