Answered

Go to next/previous date via an icon, then filter gallery with this date

(0) Share

Report

Posted on by Lvdk

Hi all,

I'm working on a screen which shows records of a SharePoint list with a specific date. A person should be able to go to the next date (with a maximum of 2 weeks), or go to the previous date. Based on that date, the gallery is filtered showing records of only that date.

I get stuck on how to achieve this. Could you give me some ideas on how to approach this?

Thanks in advance!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,738 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Lvdk ,

Set a Variable at Screen OnVisible

UpdateContext({vDateMove:0})

Now on your back arrow

UpdateContext({vDateMove:vDateMove-1})

and your forward arrow

UpdateContext({vDateMove:vDateMove+1})

now your Filter (you will have to add whatever else you have in it)

Filter( YourList, DateDiff( YourListDateField, YourTestDate, Days )=vDateMove )

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.
WarrenBelz 156,738 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Lvdk ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.
Lvdk on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Yes, many thanks! I only made a small adjustment in the filtering. In stead of using the DateDiff I used the DateAdd function: