Answered

Power Apps Calendar Template-Sharepoint List- multiday events

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I was manipulating the premade calendar template in microsofts powerapps to make a calendar based off a list instead of connecting to my outlook account. Im having trouble with multiday events not showing up in the right side of the template (where is shows what events are happening). The picture is the current code in the line, just need help having an event the spans over multiple days show up on the right side. I was able to put in the items the first ("StartDate") and the last day of the event ("EndDate"). In my list, i only have two date columns.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

WiZey 3,023 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello @Anonymous ,

The following formula should help you:

Filter( datasource, And( StartDate <= selectedDate, selectedDate <= EndDate ) )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@WiZey Thank you for the help, the code worked for the right side of the template. The only issue is that now its showing all the events for the month rather than just the events on that day. Any more help is appreciated.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

never mind that issue, I had input the selected date incorrectly and used different dates.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@WiZey Hey I need help on one more thing within my app. I wanted to get this error fixed and I haven't figured it out yet. One of the pictures is the powerapp and the other is the data set it is using. I just want the dots to start at the "StartDate" and go through until the "EndDate" from my list. Anything helps.

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (0)

Report
Copy link

Link copied!
Check the dots' "Visible" property, you'll see they're based on the existence of an event at a date.

If you want to make the dots visible based on the selected record of your gallery, you can change the dots' "Visible" property to something like this, if you're using the exact same calendar Power Apps gave you as a sample:

Circle.Visible: And( Gallery.Selected.StartDate <= DateAdd(_firstDayInView;ThisItem.Value;TimeUnit.Days), DateAdd(_firstDayInView;ThisItem.Value;TimeUnit.Days) <= Gallery.Selected.EndDate )

Or, if you want to use all the records at once, you can calculate the earliest "StartDate" and the latest "EndDate" to get a range of date. The "And()" function uses the variables "_startDate" and "_endDate" instead of the gallery's item.

With( { _startDate: Min(Gallery.AllItems; StartDate); _endDate: Max(Gallery.AllItems; EndDate) }; And(...) )

Was this reply helpful? Yes No