cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DBK2
Helper IV
Helper IV

Need to create calculation value in Dataverse table columon

I have a table with below values, I need to put condition in Dataverse column in Action section, Here Material is choice column, if user select Stick, value is 100*5.3 and if user select Value   is 200*6.3..like so on...need to calculate value to calculate value column. 

WeightMaterialValue
100Stick 
200plate 
1 ACCEPTED SOLUTION

Accepted Solutions
bipinshan
Solution Sage
Solution Sage

Hi @DBK2 ,

 

You can easily achive this with Calculated field.

https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/define-calcula...

 

bipinshan_0-1640688925489.png

 

bipinshan_1-1640688976148.png

 

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: https://xrmdynamicscrm.wordpress.com/

View solution in original post

2 REPLIES 2
bipinshan
Solution Sage
Solution Sage

Hi @DBK2 ,

 

You can easily achive this with Calculated field.

https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/define-calcula...

 

bipinshan_0-1640688925489.png

 

bipinshan_1-1640688976148.png

 

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: https://xrmdynamicscrm.wordpress.com/

rampprakash
Super User
Super User

Hello @DBK2,

 

Hope you are doing good. As per OOB behavior this can be achievable. 

 

Please follow below steps to achieve the same.

 

1. Navigate to https://make.powerapps.com

2. Choose the Respective Environment --> Expand Dataverse --> Click Tables

3. Select the Respective Table where Calculated Field Available --> Click Open Calcuation

rampprakash_0-1640689975379.png

 

4. Once Page Opened You can write Condition like below

 

rampprakash_1-1640689995662.png

 

That's it 🙂

 

 

Please mark as Answer if it is helpful and provide Kudos


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

 

 

 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,889)