Hi,
I am creating a calendar view for one of my projects in Power apps (without using any PCF control).
The calendar should look like this below
I am currently trying to implement the day view. As you can see, the app should use outlook connectors to show the shared calendar (shared with the logged in user in power apps) appointment on power apps tool. For example, you can see the Petra's appointment or event (for a day) easily without opening the outlook calendar.
First (to get number of data between 8am to 7pm, at 60 minutes interval), I created collection using sequence and also to hold the integer value of the relevant time, I used DateDiff function, so it looks like below
With(
{
tvBlankSchedule: AddColumns(ForAll(Sequence(49),Time(8, 15 * (Value - 1), 0)),ValueInt,
DateDiff(
TimeValue("12:00 AM"),
Value,
TimeUnit.Minutes
)
)
},
ClearCollect(colCalendarDraft,
ForAll(
Sequence(CountRows(tvBlankSchedule)),
Patch(
Index(tvBlankSchedule, Value),
{RowNo: Value}
)
))
);
After this I used Get calendars action (by calling Power automate flow) and got the shared calendars (of Petra and Mirjam) and then used "Office365Outlook.GetEventsCalendarViewV2" to get the events for every shared calendar and created another collection to store this. Then created similar like above, I added two more columns (start app time and end app time) in appointmentevent collection which has the date diff value from 12:00 am in int. value and then I compared those columns with the ValueInt column of colCalendarDraft to get the final collection (named as colCalendarFinal)
The colCalendarFinal looks like this for any selected date now, where Appointment column has the table of appointments of events
So after this, I used horizontal gallery which will keep the time (from 8am to 12am) using the colCalendarFinal collection and under that I used another vertical gallery (nested gallery) to showcase the events from each person, the nested gallery items is bounded to Filter(ThisItem.Appointment, CalendarOwner in uniqueEmailCollection2), where uniqueEmailCollection2 has email ids of the persons (Petra etc.). One button has been added to the nested gallery to showcase the event subject and calendar owner (email Id of the shared calendar owner)
Here, I need to showcase the all same appointments (same subject) for one person in same line and also instead of showing multiple names for same appointment subject, it should show the subject name only once. As you can see below, subjects are appearing multiple times for same appointment with same subject and also same appointment (with same subject) for one person are not in same line.
Please let me know if you can suggest something on this. How should I position the button or do I need to change some element in the button.
@Pstork1 @WarrenBelz please let me know if you can also assist in this.
Thanks.
