Convert date format from a gallery to a collection in Power Apps (mm/dd/yyyy ---> mm/yyyy)

(0) Share

Report

Posted on by Santiago241

Hello, I'm working on an issue related to Power Apps and I need help with converting the date format from a gallery to a collection.

I have a gallery that fetches data from a data source. Within this gallery, there is a column with dates in the "dd/mm/yyyy" format. I would like to transfer the information from this gallery to a collection with the format "mm/yyyy". I've tried modifying the "Default" property of the DatePicker control by setting it to "mm/yyyy", but the format is not saved in the collection.

I also attempted to use the following formula: Text(ThisItem.item_SaleDate, "mm/yyyy"), but I couldn't achieve the desired format.

I would greatly appreciate it if you could provide me with a solution or alternative to achieve the desired format when saving the data into the collection.

Thank you very much for your assistance!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Santiago241 ,

I've made a test for your reference:

1\I assume there is a collection:

ClearCollect(Collection1,{Column1:"A",DateColumn:Today()})

2\You could try this formula:

ClearCollect(NewCollection,ForAll(Collection1,{Column1:Column1,DateColumn:Text(DateColumn,"mm/yyyy")}))

Best Regards,

Bof

Was this reply helpful? Yes No