Unanswered

Error on Export to CSV/EXCEL Date Format

(0) Share

Report

Posted on by GinFSG

Hi All,

I encounter error on the data exported in date columns, Date is format is "General" which should be "Date" like the first and second row. and the value should be "6/1/2021". I don't know why it generated "1622476800000".

Per checking on the config, I've notice that the app labels were not highlighted when used in formula and on the collection, the other data for dates starting the third row is missing.

Would greatly appreciate any help

Thank you very much

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

v-jefferni on at

Like (0)

Report

Hi @GinFSG ,

After testing on my end, I could confirm that when using ForAll along with Gallery.AllItems, control names in Collect function would not be highlighted.

Look into your formulas, it is a collection "colExportDetails" but not the excel table, what is the formula for patching to Excel?

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
GinFSG 11 on at

Like (0)

Report

Hi, Sir @v-jefferni

I believe, ForAll along with Gallery.AllItems was working a day ago.
Yes. "colExportDetails" is the collection I used to be exported on excel that came from the gallery "galAllInvoicesMainHidden".

Attached is my full function for my button control.

Thank you @v-jefferni

Function.docx

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @GinFSG ,

Although control names are not highlighted, the functions are working with no issue. So the wrong output seems from the Flow, could you please share your detailed Flow with me?

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
GinFSG 11 on at

Like (0)

Report

Hi, @v-jefferni

Here's the screenshot of my flow.

"from": "@json(outputs('Content'))",

Here are the first four input from "Create CSV Table" on my last run.
Thank you 🙂

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report
Hi @GinFSG ,

I made a test and found that if there are blank values in inputs, some of them would display as those strange numbers.

So, please try and add an If statement into the date received column:

'Date Received':If(!IsBlank(Lable.Text,Lable.Text,""))

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
GinFSG 11 on at

Like (0)

Report
Hi Sir @v-jefferni

Thank you very much! It works!

Just have to edit the formula.
'Date Received':If(!IsBlank(Lable.Text),Lable.Text,"")

Was this reply helpful? Yes No
GinFSG 11 on at

Like (0)

Report

Hi, @v-jefferni

It does not work again.
My download file when it worked.

Now, I have encountered the same issue again.

Attached is my current function/formula.

Funtion2.docx

Was this reply helpful? Yes No
GinFSG 11 on at

Like (0)

Report

Hi, @v-jefferni @RandyHayes @CNT @WarrenBelz @Pstork1

Hope you could check this please.
Would highly appreciate any help.
Thank you.

Was this reply helpful? Yes No