Filter delegation error with sharepoint list (startswith and =)

(0) Share

Report

Posted on by melsch123

Hi,

I'm getting a blue dot error for filtering a data table like this:

Filter(MyList, StartsWith(Title, ThisTitle), StartsWith(Class,ThisClass), DateDiff(Created, Today())=0).

The last part of the filter (intended to only show records created today) causes the error.

I'm worried that MyList will eventually exceed 500 records and the latest records (the ones i'm most interested in for this filter) are at the bottom of my sharepoint custom list. Will this filter stop working once the list exceeds 500 items? Is there a way to ensur that the 500 items that are evaluated in powerapps always include the latest ones?

Thanks in advance for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-micsh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @melsch123,

I moved your posts from Microsoft Flow to PowerApps general discussion.

For delegation, please check:

https://docs.microsoft.com/en-us/powerapps/delegation-list

To workaround this, we could first sort the List based on the ID column,

For example:

Filter( SortByColumns(MyList, "ID", Descending), StartsWith(Title, ThisTitle), StartsWith(Class,ThisClass), DateDiff(Created, Today())=0)

Regards,

Michael

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @melsch123

Have you tried setting a variable beforehand and then filtering by it instead of filtering by the Today() function?

So, on App OnStart or on Screen's onVisible (depending on your needs/usage)
= Set( TodaysDate, Today() )

Then when filtering, have it as follows:

Filter(
MyList,
StartsWith(Title, ThisTitle),
StartsWith(Class, ThisClass),
Created=TodaysDate
)

Was this reply helpful? Yes No
Milansinh Raj 149 on at

Like (0)

Report
Copy link

Link copied!

You can increase your record limit to 2000 from Advance settings if needed.

Was this reply helpful? Yes No