Hello Mates,
I have to display a calendar and selected dates label on a Bashbord screen to filter the created on range items from SP list. please help me to build it from start level.
You can have a look on below screen for exactly what I'm looking.
Thanks in advance.
Solved! Go to Solution.
Hi @ShaikSayyad
CountIf('Data Source Name',Region = "Region1" && DateCol >= DatePicker1.SelectedDate && DateCol <= DatePicker2.SelectedDate)
Hi @ShaikSayyad
"Selected Dates: "&DatePicker1.SelectedDate&" - "&DatePicker2.SelectedDate
Hope this Helps!
Hello
Thanks for your suggestion, it would good idea to use date pickers but how can I filter no of records from SP list in between those two selected dates. you can refer my requirement on below screen.
I have a label to display the no of records with region value condition, could you please let me know how to resolve it.
Hi @ShaikSayyad
CountIf('Data Source Name',Region = "Region1" && DateCol >= DatePicker1.SelectedDate && DateCol <= DatePicker2.SelectedDate)
Hi Yash,
It was not showing true count, my date and time column has in standard date and time format as you can see below screen
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
198 | |
171 | |
60 | |
32 | |
32 |
User | Count |
---|---|
333 | |
271 | |
103 | |
71 | |
56 |