How to sort à calculated column

(0) Share

Report

Posted on by fred_05100

Hi,

I've got a calculated column (datetime type) :

It's using value from lookup table "type_demande".

I was very happy that it worked.

But now I'm facing an important issue : I can't sort on that column (because it's calculated according to what I read)

I could use flows but I need to use premium flows and I don't have the license.

Do you have any other solution to propose ?

Frederic

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (2)

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
HI @fred_05100,

Currently, Power Apps does not support to sort calculated columns directly.

You could try to calculate the date time directly in PowerApps, then save this calculated value into a temporary column by AddColumns(), finally you could sort by this temporary calculated column directly.

SortByColumns( AddColumns( list, "CalculatedField" <your-datatime-calculated-formula> ), CalculatedField, Descending )

Was this reply helpful? Yes No
fred_05100 51 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Thanks.
You mean i should use JavaScript ?

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @fred_05100,
No, you don't need JavaScript, @v-qiaqi-msft post was assuming you were using canvas apps, not mode-driven apps. You can filter calculated columns out-of-the-box with views (see image below). What is the exact error you are having?

BTW: you can use Power Automate if you have a Power Apps license (or D365) you can use Power Automate to automate logic related to these apps and Dataverse without separate Power Automate licenses.

Another tip: calculated columns are getting deprecated, suggest using Formula columns if you can and it also supports sorting.

Hope this helps!

Was this reply helpful? Yes No
Verified answer

Jonathan Manrique 2,695 on at

Like (0)

Report
Copy link

Link copied!

Hi @fred_05100

The calculated columns will be replaced by the Power FX formula columns, where you will be able to perform the calculations.

Work with Dataverse formula columns - Power Apps | Microsoft Learn

Then if you can order it

An important point is that for the moment we do not accept the currency.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution
Follow me on Linkedin, I talk about Power Platform
www.linkedin.com/in/jonathan-manrique-rios

Was this reply helpful? Yes No
fred_05100 51 on at

Like (0)

Report
Copy link

Link copied!

Hi Thanks,

Was this reply helpful? Yes No
fred_05100 51 on at

Like (0)

Report
Copy link

Link copied!

Hi Thanks

Was this reply helpful? Yes No
fred_05100 51 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Thanks,
When I perform a sort in a view as you suggest, It doesn't work.
But I will try formula FX.

Was this reply helpful? Yes No