Exporting values from objects to CSV

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey there 🙂

New day new problem... 🤣

Settings (the working part):

- SharePoint list with dropdowns, lookups, ect...

- Using this list in PowerApps in a gallery

- saving data from this gallery in a collection:

ClearCollect(Collection1; ShowColumns(Gallery1.AllItems;"Besteller";"Verwendung"))

- parsing this via PowerAutomate in a CSV file

Exporttest.Run(JSON(Collection1;JSONFormat.IndentFour))

Everything fine!

Now to my problem: The output in my CSV file is weired.

Instead of only "Jana" the flow saves "{Value":"Jana"} in my file.

Why? Because it is an object?

{
 "type": "array",
 "items": {
 "type": "object",
 "properties": {
 "Besteller": {
 "type": "object",
 "properties": {
 "Value": {
 "type": "string"
 }
 }
 },
 "Verwendung": {
 "type": "string"
 }
 },
 "required": [
 "Besteller",
 "Verwendung"
 ]
 }
}

Is there any way to "fix" that? I think somewhere I made a mistake, but where... 🤔

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

mahoneypat 1,720 on at

Like
a
(0)

Report
Copy link

Link copied!

It seems like it is working but that your input collection may not be correct. How was it created? Did you put " " around the Value column name when creating that table?

Regards,
Pat

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I've done it via PowerAutomate:
Parse JSON --> Generate from sample

see here: https://youtu.be/AUHm8r3Y5nY?t=829

Was this reply helpful? Yes No
mahoneypat 1,720 on at

Like
a
(0)

Report
Copy link

Link copied!

Looking at your JSON schema again, the Bestseller field is a property of sub object while the Verwendung field is not. In your CSV action in your Flow, use the Custom/Manual option (instead of Automatic) and you can access the Bestseller field with an expression with item().Bestseller.Value while the Verwendung one stays the same as item().Verwendung (add that field with Dynamic properties and then hover over it to confirm.

Regards,
Pat

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Pat,

I'm not quite sure that I've done it the right way...

Hovering:

Was this reply helpful? Yes No
axy5093 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous @mahoneypat , i have a similar problem where two of of my values is being exported as an object.

Below is my JSON Schema,

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "A": {
                "type": [
                    "string"
               ]
            },
            "B": {
                "type": [
                    "string"
               ]
            },
            "C": {
                "type": [
                    "object" //Had to add object as the field is a SharePoint choice field
                  ]
            },
            "D": {
                "type": [
                    "object"
                ]
            },
  },
        "required": [
            "A",
            "B",
            "C",
            "D",
            ]
    }
}

Fields C and D get exported as values just like @Anonymous bestseller field
Am new to PowerApps appreciate any help i can get.

Was this reply helpful? Yes No