How can I Fix this Delegation Warning

[Jrldscrpz]

Good Day, I am having a hard time  with this "Delegation Warning The highlited part of this formula ..."  . How will I fix this? Any recommendations please. See the Screenshot for better understanding. Thank you very much

[Jrldscrpz]

Up

[iAm_ManCat]

Hi,

I'm going to assume you are using SharePoint as a storage medium based on the error - You can't currently filter by date range as a delegable action from SharePoint, only number fields (not date fields) - see https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list

Also, just to clarify on your formula (if it Was possible) - your formula is saying that the Created date is Less Than the From Date, and Greater Than the To date, so that's choosing any dates that are outside of the date range you set.

I think what you wanted was to say was: 

> fromDate

< toDate

Additionally, if you move your backend to Azure SQL you will be able to delegate < > date filtering by using a calculated number field of format YYYYMMDD (doing this from SharePoint will still incurr the issue with delegation, so it must be from Azure SQL).

@PaulD1's older post highlights this ( https://powerusers.microsoft.com/t5/General-Discussion/Gallery-Filter-by-a-date-SharePoint-List-Part... )

Hope this helps!

[Jrldscrpz · Accepted solution]

Sorry for the Very Late Reply.

So what I did was I transfer the data of my sharepoint list into a  collection, and I did the filtering in my collection. It works fine

Thank you very much!