Answered

Add Text Column of Filtered Date Value in Collection

(0) Share

Report

Posted on by ruihaolrh

473

My formula below stores a 'Date' and 'Name' value. However, I want to add another column to store the 'Date' value in dd/mm/yyyy format because the date is displayed in a Gallery.

 //Store Public Holidays Date and Name
ClearCollect(
 ServiceCalendarDateAndNameBetweenSelectedDates,
 AddColumns(
 Filter(
 varDateRange,
 Value in Filter(
 ServiceCalenderDateAndNameCol,
 Date = Value
 ).Date
 ),
 "Name",
 LookUp(
 ServiceCalenderDateAndNameCol,
 Date = Value
 ).Name
 )
 );

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @gymcode ,

If the dates are just using for displaying in Gallery, you can have a Text function for the Label in Gallery for the initial Date column:

Text(ThisItem.Date, "dd/mm/yyyy")

Best regards,

Was this reply helpful? Yes No
ruihaolrh 473 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni , the existing date column is used for further filtering before deciding which dates to be displayed, therefore I cannot convert this column to Text, but an additional column is needed.

My gallery that currently displays the Date (Value) and Name (Name) value:

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @gymcode ,

In the Gallery you can have several Labels for displaying one column in different formats. Anyway, to add another column in the collection, you can use below formula:

//Store Public Holidays Date and Name ClearCollect( ServiceCalendarDateAndNameBetweenSelectedDates, AddColumns( Filter( varDateRange, Value in Filter( ServiceCalenderDateAndNameCol, Date = Value ).Date ), "Name", LookUp( ServiceCalenderDateAndNameCol, Date = Value ).Name, "FormatDate", Text(Value, "dd/mm/yyyy") ) );

Best regards,

Was this reply helpful? Yes No