Hi there, I'm having an ongoing issue I can't solve using chatGPT, so hoping someone here can point me in the right direction. It might be a long one, but I'll explain it the best I can.
I'm creating a Dynamic Calendar which is linked to a Microsoft List called 'Board Reporting Tracker 2025'. The objective is to have a calendar view that is easy to see key dates for those that work on Board reports for a finance companty. I want the calendar to display buttons on the days that things are due, however there are multiple due dates... ie. RP review date, paper due, meeting date, stakeholder engagement date. All of these dates need to show on the calendar and they will be for 1 item.
I started by following this YouTube video
https://www.youtube.com/watch?v=NAEZ4m-EjDA&t=1155s which was super helpful, up until I realised I needed to display different buttons for different types of due dates. This video shows how to display work items with a due date (fine).
This is how it currently looks. As you can see, I have 1 item (Test paper) and it displays the dates when Line 2 Stakeholders need to be engaged (6th), when the test paper is due to RP for review (17th), when the test paper is due for submission (20th) and when the actual meeting isd (24).
Now, the issue I'm having is that, to display all those buttons, I had to create separate galleries. Not ideal, as I'd rather just have the 1 Gallery under the GalleryCalendarMain which displayed all buttons based on filtered formulas, but I couldn't seem to get that to work. So I created different galleries, all with their own unique buttons.
The issue I'm having now, is that I want each of those buttons/labels to be clickable and open up to a form so that the user can edit the dates of the item. For some reason, the Button5 works perfectly. It opens Form7 under EditItemScreen and then I can save the update. But when I copy the OnSelect formula to Label4 and Button6, nothing happens. They dont even become clickable. I'm going around in circles, I'm not sure how to fix this or why the OnSelect formula wont work.
The formula I have to Button5 is
Set(selectedItem, GalleryRPReviewDate.Selected);
EditForm(Form7);
Navigate(EditItemScreen, ScreenTransition.Fade);
Label4 and Button6 is the same, but with it's corresponding Galleries as the Gallery name. But, no action is being taken. Chat GPT was asking me about the Item fomula on GalleryCalendarMain which is
ForAll(Sequence(42),Value+varCurrentDate-Weekday(varCurrentDate)).
But, if I change this, it stuffs the whole calendar. Would anyone have any idea why the OnSelect properties aren't working on the GalleryMeetingDate and GalleryPaperDue galleries? Or alternatively, is there a way I can just have 1 Gallery under the Main Calendar Gallery that looks up the Microsoft list and creates a different button for each item that falls in the seperate due dates? Hopefully this makes sense?
Each of the Gallery items have the following properties:
Filter('Board Reporting tracker 2025','RP review date'=ThisItem.Value)
Filter('Board Reporting tracker 2025','Meeting date'=ThisItem.Value)
Filter('Board Reporting tracker 2025','Paper due date'=ThisItem.Value)
Any insight would be great. If you need any further information on any formulas I've used, please let me know and I can copy them across.