How can I sort the output of the Power Automate flow before writing to Excel? I have an export to Excel function that generates output without {:””}; however, it is not sorted based on the input in OnSelect.

[ericasalcedo]

How can I sort the output of the Power Automate flow before writing to Excel? I have an export to Excel function that generates output without {:””}; however, it is not sorted based on the input in OnSelect.

[v-yueyun-msft]

Hi , @ericasalcedo 

Column sorting in Power App is sorted by the first character by default and can't be changed. If you want to change the sorting of columns imported into excel, you'll need to do so in Power Automate side.

item()?['Your Field Name']

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[ericasalcedo]

In the approaches without Parse JSON, the fields I need to add are not in the choices in Dynamic Content.

The approach with Parse JSON is showing the options. However, the columns in the Excel output are not sorted according to what was set in Create CSV table and is showing {:""} JSON format.

[v-yueyun-msft]

Hi, @ericasalcedo 

That's because the value you're passing in from Power Apps into flow is {Value:"xxx"}.

First method, you can update your Power App side code to pass the Text instead of the Record data.

Second method, you can directly try to use the expression in flow and you do not need to use the dynamic content.

item()?['Employee']?['DisplayName']

If this expression can not work , you can also try to use this expression:

json( string( item()?['Employee']) )?['DisplayName']

If you cannot solve the issue , you can give me your output of "Power Apps V2" action in your flow run history.

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[ericasalcedo]

With item()?['Employee']?['DisplayName'], I'm getting the error that "This expression is invalid."

json( string( item()?['Employee']) )?['DisplayName'] is recognized by the system; however, the output is incorrect. The output result is showing {:""} JSON format.

[v-yueyun-msft]

Hi , @ericasalcedo 

Thanks for your response! Can you copy me your input of your "Create csv table" action in your flow run history?

Can you show me this in your side?

And the "Employee" column is 3nd column in your create csv table. Why the column is 1st column in your csv table?

Best Regards,

Yueyun Zhang

[ericasalcedo]

{

    "inputs": {

        "from": "@json(body('Parse_JSON'))",

        "format": "CSV",

        "columns": [

            {

                "header": "Overall T.E.N.Rating",

                "value": "@item()?['Overall T.E.N. Rating']"

            },

            {

                "header": "ReferenceNumber",

                "value": "@item()?['Reference Number']"

            },

            {

                "header": "Employee",

                "value": "@json( string( item()?['Employee']) )?['DisplayName']"

            },

            {

                "header": "Manager",

                "value": "@item()?['Manager']"

            },

            {

                "header": "InteractionDate",

                "value": "@item()?['Interaction Date']"

            }

        ]

    },

    "metadata": {

        "operationMetadataId": "bd3dc098-f343-4f93-9d51-9082dc1a5f0c"

    }

}

[v-yueyun-msft]

Hi , @ericasalcedo 

Thanks for your response ! Can you try to use this expression:
item()?['Employee']?['DisplayName']

item()?['OVERALL_x0020_T_x002e_E_x002e_N_']?['Value']

And for your above reply , you use the "item()?[Employee]?[DisplayName]" so it return invalid expression. You need to add the '' around your fiedName:
item()?['Employee']?['DisplayName']

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[v-yueyun-msft]

Hi , @ericasalcedo 

Thanks for your response ! Can you try to use this expression:
item()?['Employee']?['DisplayName']

item()?['OVERALL_x0020_T_x002e_E_x002e_N_']?['Value']

And for your above reply , you use the "item()?[Employee]?[DisplayName]" so it return invalid expression. You need to add the '' around your fiedName:
item()?['Employee']?['DisplayName']

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[ericasalcedo]

I made the change in the input. The result did not change.

[v-yueyun-msft]

Hi , @ericasalcedo 

Thanks for your response!

Can you check if the output of your "Create csv table" has been updated in your flow run history?

If this has changed, can you show your action after your "Create csv table"?

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[ericasalcedo]

ExportToExcelParse is not updated.

[v-yueyun-msft]

Hi , @ericasalcedo 

Thanks for your response! I am not surely understanding the meaning of "ExportToExcelParse is not updated"

Can you give me a screenshot for your "Create csv table" action output in your flow run history, like this:

Best Regards,

Yueyun Zhang

[v-yueyun-msft]

Hi , @ericasalcedo 

I test it in my side, it works good , this is my input of my "Create csv table":

Best Regards,

Yueyun Zhang

[ericasalcedo]

ExportToExcelParse is one of the Power Automate flows used in my application in Power Apps. It uses Parse JSON. The recent flow runs are not displayed in Power Automate when triggered in the Power Apps application.

When triggered in Power Automate as a test, Parse JSON failed.

Input:

Output:

Create CSV Table in output is showing this error.

[ericasalcedo]

Create CSV Table in output 

[v-yueyun-msft]

Hi , @ericasalcedo 

Thanks for your response ! You flow failed so it do not execute the actions after your "Parse json" action.

In my thought , You do not need to use the "parse json action", You just directly use the function here:

json(triggerBody()['text'])

Best Regards,

Yueyun Zhang

[ericasalcedo]

I tried several approaches including those that do not use the Parse JSON step. 
In one of the steps Create CSV Table uses that function (json(triggerBody()['text'])) already. 

The columns are sorted alphabetically. I need the columns in a specific order set in OnSelect as mentioned in the original post.

[v-yueyun-msft]

Hi , @ericasalcedo 

Thanks for your response! You can make the custom column order here:

And you need to put the code in Expression pane and add it to right pane "Value".

And you can see my first column is [PersonTest], second column is [Title]. This is my result in my csv file:

Best Regards,

Yueyun Zhang

[ericasalcedo]

I made the change.

The output was not generated.