Display All Rows in a Collection as Text or Table

(0) Share

Report

Posted on by ruihaolrh

473

My Collection table stores 2 columns, Name and Value.
*Date below is in mm/dd/yyyy format

For all rows, I want to sort them by Date (ascending - earliest on top, latest at bottom), and display in a multi line text field, or a table if it is possible:

If Text:
1) 09 Feb 2024 - Event A
2) 10 Feb 2024 - Holiday B
3) 09 Aug 2024 - Holiday A
4) 04 Sep 2024 - Holiday C

If Table:

#	Date	Reason
1	09 Feb 2024	Event A
2	10 Feb 2024	Holiday B
3	09 Aug 2024	Holiday A
4	04 Sep 2024	Holiday C

Any assistance would be greatly appreciated. Thank you.
___________________________________________________________________________________________________________________________________________

Below is my formula for the collection, if it helps.

 ClearCollect(
 ServiceCalendarDateAndName,
 AddColumns(
 Filter(
 varDateRange,
 Value in Filter(
 'Service Calendars',
 'Service Calendars (Views)'.'Active Service Calendars'
 ).Date
 ),
 "Name", LookUp('Service Calendars', Date = Value).Name
 )
 );

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @gymcode

can you try this please:

Sort(Collection, Value, Ascending)

hen, you can use this sorted collection to display the data as needed.
For a multi-line text field, you can concatenate the sorted dates with their respective names. Here's an example of how you can do this with a ForAll loop and the Concatenate function:

Concatenate( ForAll( SortedCollection, Concatenate(Text(Index), ") ", Text(Value, "dd MMM yyyy"), " - ", Name, Char(10)) ) )

For a table, you can use a Data Table control or a Gallery control to display the sorted information. You would set the Items property of the Data Table or Gallery to the sorted collection.
To format the date within the table, you can use the Text function in the label control within the Gallery like so:

Text(ThisItem.Value, "dd MMM yyyy")

Please replace Collection with the actual name of your collection and SortedCollection with the name of your variable where you store the sorted table.

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
ruihaolrh 473 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mmbr1606 , thank you for the formulas.

1. For the sort formula, I skipped this first as I'm not sure how to implement it.

2. For the concatenation of the table rows into a text, I'm facing an issue where it says 'Expected Text Value'
Below is my current formula on the concatenation:
Concatenate( ForAll( ServiceCalendarDateAndNameBetweenSelectedDates, Concatenate(Text(Value, "dd MMM yyyy"), " - ", Text(Name), Char(10)) ) )
Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
can u try this modification:

Concatenate( ForAll( Sort(ServiceCalendarDateAndName, Value, Ascending), Text(Index) & ") " & Text(Value, "dd MMM yyyy") & " - " & Name & Char(10) ) )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings