Share
Report
12Dear community,
I hope somebody can help me.
I am creating a car pooling solution for booking a company car.
The car pooling solution gets data from a Sharepoint list that stores all the booking requests.
In my power apps homepage I have created a calendar overview that shows the dates when the car is already booked. I want to show this by showing the date range from the sharepoint list by making the subcircle visible as seen below.
Unfortunately I am getting an error and I dont know how to solve it.
This is the code I have :
CountRows(Filter(
'Car Pooling Admin',
DateValue(Text('Start Time')) <= DateAdd(
_firstDayInView,
ThisItem.Value,
TimeUnit.Days
),
DateValue(Text('End Time')) >= DateAdd(
_firstDayInView,
ThisItem.Value,
TimeUnit.Days
)
)
)
Do anyone have an idea on how to solve it?
All responses (
Answers (
