web

You’re offline. This is a read only version of the page.

News and Announcements icon

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

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No

Join the conversation