Power FX in calculated Column

(0) Share

Report

Posted on by BeR001

Dear all,

I read that we can use Power Fx in the calculated column in a preview released in September.

It is clearly something I need !!
But I can't find what I have to do to switch to the "preview mode" in dataverse.

Does someone know how to do that ?

Thank you in advance.
Ber

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hello @BeR001,

Hope this can help https://www.youtube.com/watch?v=09V0IMGlG6Y

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
BeR001 39 on at

Like (0)

Report

Hi Rampprakassh,

Thank you unfortunately not... I thanks to this video I have discovered this new feature but they don't explain how and where you can activate this preview feature...

Bertrand

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,413 Moderator on at

Like (1)

Report
@BeR001

Please check the below blog:

https://powerapps.microsoft.com/en-us/blog/power-fx-formula-columns-in-dataverse/

As per my understanding to the paragraph below it is only available right now to Dataverse for Teams and not through the maker portal but if it is available through the maker portal , it should be through make.preview.powerapps.com

The formula editor supports IntelliSense to suggest formulas and errors in real time.

In public preview:

The editing experience is limited to Dataverse for Teams, but we have plans to bring it to the maker portal soon.

This feature supports decimal, currency, Boolean, lookup and limited date/time functionality. More to come.

On read, all calculations are on done on the fly as added projections of the SQL Select query. Results are real time. We are also working on other modes of operation, where values can be calculated and stored on write. This would enable support for rollups of one-to-many and many-to-many relationships, something else we are working on.

This feature will be available in few regions starting this week with more regions lighting up in next 6 weeks.

Hope this helps!

Was this reply helpful? Yes No