web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Weird behaviour when u...

Power Apps

Answered

Weird behaviour when using Filter + Distinct against a SharePoint list

(0) Share

Report

Report

Posted on by AlexJohn

4

Hello,

I am using this formula in a dropdown element:

SortByColumns(Distinct(Filter(Wochenbericht;(KWNummer<=varKWN));KWNummer);"Result";Descending)

varKWN is the current weeknumber and I define it like

Set(varKWN;ISOWeekNum(Today()))

It has the correct value. The sharepoint I use to get data has around 7000 entries with pretty much all weeknumers (multiple).

When I use the formula above, I only get the weeknumers between 1 and 8. So it is missing some. When I change the formula to

SortByColumns(Distinct(Filter(Wochenbericht;(KWNummer=varKWN));KWNummer);"Result";Descending)

I do get the weeknumer 18 that was missing.

I recorded it as a gif:

Oqb9W11

I also get no delegation warning. What am I missing here? 😞

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AlexJohn ,

Distinct() is a "hidden" delegation limitation, so you can do this

With( { wList: Filter( Wochenbericht; KWNummer <= varKWN ) }; SortByColumns( Distinct( wList; KWNummer ); "Result"; Descending ) )

providing the top filter returns record numbers under your Delegation limit.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
AlexJohn 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Thank you, this looks very good!

Was this reply helpful? Yes No

Join the conversation