Not able to add SharePoint dates to PowerApps collection

(0) Share

Report

Posted on by AnuragT

I have a SharePoint list with approx 20 columns. I am trying to add those in PowerApps collection using ForAll formula. This way, I am able to add everything but not dates from SharePoint's date column name Created. I tried following codes (Inside ForAll loop)

ForAll(
Collection,
Collect(
colMonth,
{
 Created: Text(DateValue(Memos.Created,"[$-en-US]mmmm")),
 Created_Month: Text(DateValue(First(FirstN(Split(Created,"/").Result,1)).Result),"[$-en-US]mmmm"),
 Created_Year: First(FirstN(Split(Last(LastN(Split(Created,"/").Result,2)).Result," ").Result,1)).Result
}
)
);

When I try to run "App Start", then all other collection columns have values but not the dates.

UnJu0 Please help.

Thank you!

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AnuragT，

Do you want to create a separate collection to display month and year value?

Could you please tell me more about your scenario?

I think there is something syntax wrong with your formula. Actually, the DateValue() function expects a number value as the first parameter, however you reference to the Memos.Created directly.

Please modify your formula as below:

ForAll( Collection, Collect( colMonth, { Created: Text(Created,"[$-en-US]mmmm"), Created_Month: First(FirstN(Split(Created,"/").Result,1)).Result, Created_Year: First(FirstN(Split(Last(LastN(Split(Created,"/").Result,2)).Result," ").Result,1)).Result } ) );