Gallery & SharePoint List - Filter & SortByColumn by specific date range doesn't work

(0) Share

Report

Posted on by koooala007

Hi All,

I have faced the problem with sorting my gallery by specific range of dates.

I would like to present only result from last 30 days.

There is Share Point List as a data source with column name Date_Of_Waste, there are stored dates.

The function i would like to use and not working yet is combination like this Date_Of_Waste<DateAdd(Today();-30;Days)

Below you can find my logic I am testing my function part by part

Working

Filter(SortByColumns('2020.03.12_(2019_2020YTD_Wro_Robot_Statistics)';"Date_Of_Waste";Descending);Break>1)

Not Working

Filter(SortByColumns('2020.03.12_(2019_2020YTD_Wro_Robot_Statistics)';"Date_Of_Waste";Descending);Break>1;"Date_Of_Waste">DateAdd(Today();-30;Days))

I would by gratefully for your support

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 154,795 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @koooala007 ,
Try - you will have to sort the mathematics
Filter( SortByColumns( '2020.03.12_(2019_2020YTD_Wro_Robot_Statistics)'; "Date_Of_Waste"; Descending ); Break>1 && DateDiff( Date_Of_Waste; Today(); Days )>30 )

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.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Try:
SortByColumns(Filter(2019_2020YTD_Wro_Robot_Statistics,DateDiff(Date_Of_Waste,Today(),Days)>=30),Date_Of_Waste)

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @koooala007 ,

Could you please share a bit more about your scenario?

Do you want to add a Date Filter criteria within your original Filter formula?

Please consider modify your formula as below:

SortByColumns( Filter( '2020.03.12_(2019_2020YTD_Wro_Robot_Statistics)'; Break > 1; Date_Of_Waste > DateAdd(Today();-30;Days) ); "Date_Of_Waste"; Descending )

Please take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
WarrenBelz 154,795 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@koooala007 ,
Three different approaches for you - they should all work - please tag the one best for you to continue with the thread.

Was this reply helpful? Yes No