Getting a Dynamic Calendar to show Events across multiple days

(0) Share

Report

Posted on by CU20031919-0

So i have built a dynamic calendar following a Youtube video. I can get the Calendar to show day 1 of an event but it wont show the remainder. I know that the formula shown in the bar is currently only asking for first day the "Departure Date" however what i want the calendar to do is show the event on each day it occurs until the "Terminating Date"

As shown below W11 departs on the 25th of March but it terminates on Thursday the 27th, what formula do i need to use to get W11 to appear in Wednesday and Thursday???????

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Daniel Bocklandt 5,117 Super User 2025 Season 2 on at

Like (0)

Report
hey you need to add the end date as well.

So something like this:

Filter('New Work train Database', 'Departure Date'=>ThisItem.Value And 'End Date'=<ThisItem.Value)

This should solve the issue.

If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!

Thanks, and happy building!

Was this reply helpful? Yes No
CU20031919-0 6 on at

Like (0)

Report

Thanks for the suggestion however - With That formula i get this....

All disappear.

If i swap =< for <= It only shows events on single days and the multi day ones do not appear at all.

Please note the "Terminating date and Time" is a date only and does not have a time value to it.

Was this reply helpful? Yes No