More than one date range into collection

[Kepcla]

Hi All,

I got this gallery:

For example, :

Start            -   End

7/10/2022  -   7/15/2022

7/20/2022   -  7/22/2022

Is there a way to store each day in a collection?

I want to have a collection with:

Date_Range = [7/10/2022, 7/11/2022, 7/12/2022, 7/13/2022, 7/14/2022, 7/15/2022]

                      [7/20/2022, 7/21/2022, 7/22/2022]

Thanks in advance!!!

[WarrenBelz · Accepted solution]

Hi @Kepcla ,

The structure below should do it

ClearCollect(
   colYourCollection,
   Filter(
      YourGalleryName.AllItems,
      (
         Start >= YourFirstStartDate &&
         End <= YourFirstEndDate
      ) &&
      (
         Start >= YourSecondStartDate &&
         End <= YourSecondEndDate
      )
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Kepcla · Accepted solution]

It works fine...

I appreciate it!