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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,091)