Real-time rollup columns AND triggers when rollup calculations are updated would be extremely helpful. Hoping we can see them sometime around this year...
Awesome video Divya and Phil! You asked - so here it is…. Something from the dark ages but still VERY much a need…but the ability to create cross tab queries views as we could in Microsoft access would be a game changer for Dataverse / Powerapps.
So in terms of use cases, can we use this with a series of IF statements to return a text value? And will we be able to do formulas based on fields in related tables into the entity we want to display the result in - without the need for doing relationship mapping?
I'd be really helpful to have the AGE CALCULATION as the 51st function please 😊. Even better if there is the ability to have three sub-options of showing it in Years only, Years & Months only and lastly in Years, Months & Days.
Let me look up a value from the first row in a filter. For example. First(filter(contacts, {condition})).email There are so maaaaany instances where i implement a lookup column and a power automate to update that column based on some simple condition. Feels wasteful
Can you use a related column using formula column from a different table? 👀 e.g. multiply a date column from main table with a number format column from a related table Thanks😊
Big shortcoming: Power FX columns cannot be used in Rollup fields. Please look into this. We desperately need a more modern replacement for Rollup fields. Make real-time rollup fields a reality and the community will forever be grateful to you
Real-time rollup columns AND triggers when rollup calculations are updated would be extremely helpful. Hoping we can see them sometime around this year...
Agreed 👍
We are taking rollup columns into consideration for 2023 wave 2 planning. 👍
Well you can trigger roll up columns by using Power Automate already, but you’ll need to build a different flow for that
Agreed!
Real time roll-up columns would be game changing
Thank you Divya and Phil!
Awesome video Divya and Phil! You asked - so here it is…. Something from the dark ages but still VERY much a need…but the ability to create cross tab queries views as we could in Microsoft access would be a game changer for Dataverse / Powerapps.
Thanks for this feedback, we are considering it in our roadmap planning.
So in terms of use cases, can we use this with a series of IF statements to return a text value? And will we be able to do formulas based on fields in related tables into the entity we want to display the result in - without the need for doing relationship mapping?
Definitely need fx for rollups!! Also Fx to work on currency columns please
what about lookup function in a formula its still not supported, is there anything similar to replace it with?
Is lookup available? I think i herad we can in video one with Mr Reva or sthm but I couldn’t do this
thanks bro. but why Formula evaluation resulted in an error
Unrelated, but when could we expect the 'to' and 'from' (multiple blob fields) to be added to CanvasApp?
I hope we can concatenate in a calculated column 🙏🙏🙏
You can! Here is the list of supported functions: learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns
I'd be really helpful to have the AGE CALCULATION as the 51st function please 😊.
Even better if there is the ability to have three sub-options of showing it in Years only, Years & Months only and lastly in Years, Months & Days.
cool
Let me look up a value from the first row in a filter.
For example.
First(filter(contacts, {condition})).email
There are so maaaaany instances where i implement a lookup column and a power automate to update that column based on some simple condition. Feels wasteful
Thanks for this feedback, we are adding this into the backlog.
@@mspowerplatform can i view the status of this backlog element somewhere?
Can you use a related column using formula column from a different table? 👀
e.g. multiply a date column from main table with a number format column from a related table
Thanks😊
If the tables are related, you can do this.
So when we say Formula columns are finally here... when is GA?
Not far - GA is anticipated in the next few months.
It’s increasingly difficult for anyone to match your energy and enthusiasm in presenting power platform features.
Big shortcoming: Power FX columns cannot be used in Rollup fields. Please look into this. We desperately need a more modern replacement for Rollup fields.
Make real-time rollup fields a reality and the community will forever be grateful to you
I agree! See Divya’s response on Rollup columns at 5:36.
Did you even see the video? She talks about it.
UNFORTUNATELY NO LOGARITHM AND EXPONENTIAL FUNCTIONS ARE SUPPORTED. IT SERVES NO PURPOSE