Answered

Newb help with sort

(0) Share

Report

Posted on by Paulow1978

Hi there,

I am just starting out woth PowerApps and struggling with a sort command. I have a simple button and a datatable (DailySales) that when the button is clicked it runs a flow. The flow returns data from a sql stored procedure in json with the following values Total sales, Cumulative sales and HourTime. I can get the data back into the table ok but I cannot sort the table by hourtime. I have attempted to do this by using this command on my button:

Set(DailySales,PowerAppsbutton.Run()); Sort(DailySales,HourTime,Ascending)

I beleive the HourTime comes back as an integer. When I click the button it does not sort the table.

I am also trying to format the table so that the TotalSales column and the Cumulative Sales are in £. Eventually I want to put it in a line graph.

I have been reading through the documentation but really struggling so any help would be greatly appreciated.

thanks!

Paul

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Paulow1978 20 on at

Like (0)

Report
Copy link

Link copied!

Well for anyone who comes across this issue, I cant figure out why it doesnt work on the button action but I clicked on the DataTable and put the sort in there and it worked. I also figured out how to create new columns and base the results in those columns on the actual columns of data (I put this on the items fx for the DataTable)

AddColumns(DailySales,"Total Sales", Text(TotalSales,"[$-en-US]£ #,###"),"Cumulative Sales", Text(CumulativeSales,"[$-en-US]£ #,###"),"Time", Text(HourTime,"[$-en-US]"))

Then I manually unticked the columns to show so that it only showed the new columns.

The problem I have now is that i cannot add the sort command at the end of the AddCoulns command even putting a ; or ;; at the end. I am trying to get it to look like this:

AddColumns(DailySales,"Total Sales", Text(TotalSales,"[$-en-US]£ #,###"),"Cumulative Sales", Text(CumulativeSales,"[$-en-US]£ #,###"),"Time", Text(HourTime,"[$-en-US]")); Sort(DailySales, HourTime , Ascending)

Was this reply helpful? Yes No
Paulow1978 20 on at

Like (0)

Report
Copy link

Link copied!

This is really frustrating...

the documentaion on powerapps is awful...

I am now trying to chain a formula for my DataTable and it won't let me. It says its expecting an operator.

I am trying to do this on my Datatable on the Items FX:

AddColumns(DailySales,"Total Sales", Text(TotalSales,"[$-en-US]£ #,###"),"Cumulative Sales", Text(CumulativeSales,"[$-en-US]£ #,###"),"Time", Text(HourTime,"[$-en-US]"));
Sort(DailySales, HourTime , Ascending)

If anyone knows why this won't work and they could help me it would be much appreciated!

Was this reply helpful? Yes No
Paulow1978 20 on at

Like (0)

Report
Copy link

Link copied!

I should also say that both forumals work on their own in the items fx just not with a ; put in between them to chain them.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Paulow

try AddColumns(Sort(DailySales,HourTime,Ascending),"Total Sales", Text(TotalSales,"[$-en-US]£ #,###"),"Cumulative Sales", Text(CumulativeSales,"[$-en-US]£ #,###"),"Time", Text(HourTime,"[$-en-US]"))

powerapps functions execute from inside out, in sequence, hence the above sorts first then adds columns to the sorted datasource. Sometimes, to be more efficient, chained functions are run in parallel. Particularly if the dataset is large, it may be trying to add columns at the same time as it is sorting and it can’t do it. (I have no idea if that’s the case but at least that’s what I imagine is happening). Also, once you add columns to the datasource, it is no longer the same datasource so the sort command on the original datasource, following the addcolumns function wouldn’t make sense.

Was this reply helpful? Yes No
Paulow1978 20 on at

Like (0)

Report
Copy link

Link copied!

You Sir are a genius 🙂

thank you so much!

Was this reply helpful? Yes No