cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VeGETz
Frequent Visitor

Insert custom row to gallery that generate from sequence function

Hi everyone,

 

I try to build a screen that will shown a 3-days calendar with daily calendar event in it. I have complete that by using nested gallery.

Now I want to add another column that contains the time at the left side (I have attached the picture of the result that I want)

 

Is it possible to put the time in the same gallery as I need it to scroll together with the Event vertical gallery

 

Does anyone know about how to do this, I try on this for a days now 😞

 

Thank you in advance.

 

gal_Days_Horizontal Items:

 

 

ForAll(
    Sequence(3),
    {
        Value: selectedDateX + Value - 2,
        NextDay3D: selectedDateX + Value - 1
        //selectedDateX default is Today() and will be change to next/previous day when user 
          click next/previous
    }
)

 

 

 gal_Events_Vertical Items:

 

 

Filter(MyCalendarEvents,Start < ThisItem.NextDay3D And End >= ThisItem.Value)
// MyCalendarEvents is a collection that stored all calendar events.

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @VeGETz :

You could set the gal_Events_Vertical Items to:

ForAll(
  Sequence(24,0,1), 
  {
   Label:Text(Value,"00")&":00",
   StartDataTime:DateAdd(ThisItem.NextDay3D,Value,Hours),
   EndDataTime:DateAdd(ThisItem.NextDay3D,Value+1,Hours)
  }
)

Add a list box into gal_Events_Vertical and set it's items:

Filter(
  MyCalendarEvents,
  Start <= ThisItem.StartDataTime And End >= ThisItem.EndDataTime
)

 


vbofengmsft_0-1632193885592.png

 

Best Regards.

Bof

 

View solution in original post

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

Hi @VeGETz :

You could set the gal_Events_Vertical Items to:

ForAll(
  Sequence(24,0,1), 
  {
   Label:Text(Value,"00")&":00",
   StartDataTime:DateAdd(ThisItem.NextDay3D,Value,Hours),
   EndDataTime:DateAdd(ThisItem.NextDay3D,Value+1,Hours)
  }
)

Add a list box into gal_Events_Vertical and set it's items:

Filter(
  MyCalendarEvents,
  Start <= ThisItem.StartDataTime And End >= ThisItem.EndDataTime
)

 


vbofengmsft_0-1632193885592.png

 

Best Regards.

Bof

 

Thank you so much. This is what I need. Now is it possible to synchronize scrolling on these all vertical galleries?

 

I see there is a way to do that posted here

by using that method I need to put all galleries into data card of scrollable canvas but when I trying to do it not let me put gallery in data card. Is there something I miss or that is not possible anymore?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,970)