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

 

View solution in original post

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,129)