Answered

ClearCollect SQL View Col Ordering

(0) Share

Report

Posted on by rashantha

I have a simple ClearCollect(Collection, SQLview);

It seems like when PowerApps reads a SQLview it puts the columns in alphabetical order instead of the order created in the view.

How can I create my Collection with the col order I need.

I am using the Collection to create an Excel file and I need the columns to be in a certain order.

As a default I would like the Cols to be in the order of the view or if possible I would like to select specific cols from the view for my export.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Pstork1 69,016 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Try surrounding the sqlview data source with a showColumns() function. That should let you pick the columns you want to include and specify the order in which they appear.

Was this reply helpful? Yes No
rashantha 65 on at

Like (0)

Report
Copy link

Link copied!

That worked partially by selecting specific cols, but when it went to export the file to CSV it did in alphabetical order.

My flow gets the content from PowerApps and runs create CSV

Was this reply helpful? Yes No
Pstork1 69,016 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What is the JSON() function you are using in the Create CSV table. Why not just pass it the output of the ContentPO Compose?

Was this reply helpful? Yes No
rashantha 65 on at

Like (0)

Report
Copy link

Link copied!
@Pstork1
thanks for your assistance.

Here's my ClearCollect statement
ClearCollect(openPOs, ShowColumns(RDS_OpenPOWarehouse,"PO_No","Item_No","Description","Rec_Date","Rec_Qty", "Qty","Exp_Date","Box_Num","Vendor_Code","Vendor"));
When I look at the collection it's alphabetical. So it seems like an issue in PowerApps.
Here's my JSON
{ "inputs": "@triggerBody()['ContentPO_Inputs']", "metadata": { "operationMetadataId": "4ae39b0c-f310-4eq1-b46e-9bedd7199775" } }

Create CSV table
json(outputs('ContentPO'))
col is set to automatic

Was this reply helpful? Yes No
Verified answer

rashantha 65 on at

Like (0)

Report
Copy link

Link copied!

The answer came from Reza Dorrani, thanks.

Use expressions in the Columns by selecting Custom.
then use the expression item().['col_name'] in the Value field and your choice in the Header field.

Was this reply helpful? Yes No