Answered

Export to PowerApps CSV but got strange output

(0) Share

Report

Posted on by Jira

I follow many Youtube about "Export data to Excel with PowerApps / PowerAutomate", I realized all are indifferent, only minor things.

Here is my screen that I follow steps, this one was my code. I dropped some fields which believe not in use when export.

and here was my flow, which succeed when click on my PowerApps

I checked details from Flow, at PowerApps and here was input detected from Flow

{

"schema": {

"type": "object",

"properties": {

"Compose_Inputs": {

"type": "any",

"description": "Inputs",

"x-ms-powerflows-param-ispartial": false

}

"required": [

"Compose_Inputs"

]

}

""x-ms-powerflows-param-ispartial": false" --> is something wrong here?

but my output look strange and not same as on several Youtube. I don't know why.

Here was the correct output that i should get after trigger my PowerApps,

(credit : excerpt from Shane Young Youtube - (Power Apps Export data to Excel with Flow - Collections to CSV file)

now I can't continue my flow, Parse JSON due to my output format from Compose stage was incorrect. Please guide, thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Jira ,

I made a test followed the steps in that video but worked fine.

Could you please recheck the variable "varDropColumn" that have you dropped all unsupported columns, such as record column like LookUp column?

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
Jira 69 on at

Like
a
(0)

Report
Copy link

Link copied!

Big thanks for your time to test my question, much appreciate on that. Below was my data structure which contains no lookup data or calculated column. For URLPhoto, I manually copy & paste from another SharePoint list.

On my first edit, I code with single column dropped out URLPhoto then I found error - "The function JSON has some invalid arguments". I add more ("Created","ID","Author","Modified","Editor","ComplianceAssetId") then such error disappeared.

Set(vardropColumn,DropColumns(SPList,"URLPhoto"));
Set(varJSON,JSON(vardropColumn,JSONFormat.IndentFour));
SP2CSV_2.Run(varJSON)

From my assumption, my SharePoint data structure contains no any lookup or calculated column. The rest fields ("Created","ID","Author","Modified","Editor","ComplianceAssetId") are automatically generated, isn't it?

Is that error related to my strange output which differ from Youtube?

Please advice,

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @Jira ,

I would recommend that you may leverage a ShowColumns function to add columns that you need to export to the CSV file into the collection:
Set(varShowcolumns,ShowColumns(SPlist,"Column1","Column2",...));

Note that in the video Shane was using a collection as the data source, which may has already dropped columns.

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
Jira 69 on at

Like
a
(0)

Report
Copy link

Link copied!

OK, let me test it and will feedback to you soon. Much appreciate in your help. Just curious why my output looks different from Youtube

Was this reply helpful? Yes No
Jira 69 on at

Like
a
(0)

Report
Copy link

Link copied!

At first I thought this strange output may relate to type of data (choice) on my SharePoint but my colleague advice me to limit number of fields display instead. I changed my code varShowColumn to display 1 to 3 fields, I successfully got output as expected (in JSON format). But I add 4th field, same strange output come.

I revisit Shane Young's Youtube, his output shown more than 5 fields. Having no clue to go. Any idea on this?

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jira ,

My test flow contains 5 parameters but working fine. Is the "UoM" column a special type column? I didn't find it in the screenshot of columns in your former post.

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
Jira 69 on at

Like
a
(0)

Report
Copy link

Link copied!

I renamed 'Unit' to 'UoM', it is Choice data type.
I rework all after column name changed.

Was this reply helpful? Yes No
Jira 69 on at

Like
a
(0)

Report
Copy link

Link copied!

I animated my screen for better explanation, sorry for my poor English. I sequence my simulation.
My curious is that I follow many MVP on Youtube step by step, but my first step output shown different, is it because number of records in demo lesser than mine or data type different?

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @Jira ,

Maybe using a collection instead of original SharePoint list could be a better approach.

Try create a collection OnVisible of the Screen:
ClearCollect(colList, SPlist));
Then replace the data source in variables with this collection.

If the issue persists, please consider raise a ticket on support page which would help more:
https://powerapps.microsoft.com/en-us/support/ or https://admin.powerplatform.microsoft.com/support

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
Verified answer

RezaDorrani 12,145 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Jira ,

check https://youtu.be/tQCBWMR7T64

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Was this reply helpful? Yes No