Unanswered

Flow to Export Collection to Excel

(0) Share

Report

Posted on by CU25110749-0

Hello Guys,

I am building a flow to export the collection to an Excel file according to this video by @RezaDorrani

This is how the flow looks

The problem that I face is that, in the step 2, I am using a Compose action and in the inputs field I am using the following expression -

json(triggerBody()['text'])

Later, in my code I have "Select" action, where in the "From" field, I have selected the outputs that I get from the "Compose" action and in the "Map" field I am unable to add columns from my Collection.

How can I add the columns in my collection here?

I have a button in my App and in the OnSelect of the button I call the flow as described below: 
Set(varExcelLink, 
   ExportdatacollectiontoExcel.Run(
        JSON(
            colFirewallInsp, 
            JSONFormat.IncludeBinaryData
        )
    )
);
Launch(varExcelLink.url)

Result: A excel file is created with a blank Table and it has the defined columns but then, values from my collection is not getting saved in those columns  as the columns are not mapped under the "Select" action in my flow.  
Kindly guide me to solve this issue. 
 
Thanks

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,969 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi,

You'd have to share the text, but remember in this case you are Dynamically generating a STring of JSON without any schema, so there is no way for it to give you Properties, as Compose won't do this.

If you use the output of the JSON into a JSON Parse and add a schema, you should see your stuff.

That or simply add the string to JSON Parse action and you will see them, assuming its well formed.

Was this reply helpful? Yes No
CU25110749-0 51 on at

Like (0)

Report
Copy link

Link copied!

Hi @FLMike, Thanks for your response.

First, when I call the flow in the App I have the following code:

Set(varExcelLink, Blank());

Set(varExcelLink,

ExportdatacollectiontoExcel.Run(

JSON(

colFirewallInsp,

JSONFormat.IncludeBinaryData

)

)

);

Launch(varExcelLink.url)

So the flow receives the JSON data from the Power Apps and this data comes from colFirewallInsp (a Power Apps collection that holds firewall inspection records)

Then in the Compose action of my flow I have

json(triggerBody()['text']) ---- So this will parse incoming JSON data from Power Apps.

What Happens in the Compose Action?

The input from Power Apps is a string representation of JSON (text format). Example: "{ \"ID\": 1, \"Inspector\": \"John Doe\", \"Result\": \"Pass\" }"

The expected Output after the compose action , The text is converted into a JSON object, For Example:

{
"ID": 1,
"Inspector": "John Doe",
"Result": "Pass"
}

So, without using a JSON Parse I should be able to see these stuff in the select action right?

Have a look at this 60seconds video clip, this is what I exactly I am trying to replicate in my app but it is not working.

Thanks

Was this reply helpful? Yes No