Hi, I'm creating a calendar based on my Leave Request list. I want the Calendar only to display the "Approved" request. The green box is the Approved leave and the black one is Pending and could be Rejected or Cancelled. How to make if Approved = green colour, others = invisible from the calendar?
How to make if there's more than 1 request in the box, both requests will be displayed. For example, there are 2 requests made on 28 June 2022 so both requester's names will appear. How to do that? Can anyone please help me?
Hi @syhrh , I'm working on similar requirements.
1. for the fill property, use the switch condition like switch(thisitem.status.value,"approved",Green,"inprogress",Orange,RGBA(0,0,0,0))
2. for your 2nd question there are two ways, 1 is use to nested gallery and pass the following filter to items property
filter(datasource, yourdatecolumn = datevalue)
use a text label and in text property show the count of requests on the day. like countrows(filter(datasource,datecolumn = datevalue)) and onclick of it show one more gallery to display all of your requests
Hi @Krishna_R, I've managed to only show approved ones. The second requirement I don't do it because I'm not too good at Power Apps and I keep getting errors so I decide not to do it.
Thank you for your help and concern.