News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Collection value to a ...

Power Apps - Building Power Apps

Answered

Collection value to a Date field

(0) Share

Report

Report

Posted on by indhaa

Hi,

So I have two screens with two forms. So what I'm trying to do is from the first screen form values I'm collecting to a collection .

So on the second screen I want to use the collection value on some of fields on the second form.

I have been able to do for some field but not able for the date field

For Text field this is working

Concat(ExternalUserCollection,FullName),

Pls let me know the syntax to do for the date field. I would like the date to be show as 'en-GB' too

Categories:

Using Apps Using Formulas

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

CNT 10,919 Super User 2025 Season 1 on at

Like (1)

Report
Re: Collection value to a Date field

@indhaa For demonstration, I've created a collection in the App,
ClearCollect(ExternalUserCollection, {FullName: "myName", ExpiryDate: "21/12/2020"})
To show this date in a DatePicker, I'm just setting some properties of the Date Picker as seen below,
Hope this helps.
indhaa on at

Like (0)

Report

Re: Collection value to a Date field

Hi

So my Date Field in the form is like this
The collection is storing the date as below

ClearCollect(
ExternalUserCollection,
{
FullName: DataCardValue73.Text,
ExpiryDate: DataCardValue116.SelectedDate
})

I first tried collecting the date field as like this
ExpiryDate: Text( DataCardValue116.SelectedDate,"[$-en-US]dd/mm/yyyy")
but it is giving incorrect date value in the form column.

Hope that clear everything for you
CNT 10,919 Super User 2025 Season 1 on at

Like (0)

Report

Re: Collection value to a Date field

@indhaa could you share the structure of your collection and also screen shots of u'r screens, to better understand what controls u r using.