Skip to main content
Community site session details

Community site session details

Session Id : cyWdaGsX3G0A96FwfE/wMb
Power Apps - Microsoft Dataverse
Unanswered

how to extract the value using lookup

Like (0) ShareShare
ReportReport
Posted on 8 Aug 2022 06:37:22 by

Hi Experts, 

 

I have developed a power app but facing some issues while doing some calculation. 

I have a table in the data verse sample is shown below.

StageVolumesent to next stage
Harvest10000(input value).4
Primary processing =(10000*0.4).5
Further processing =(10000*0.4*0.5) 

 

In the forms where user can enter the values of  volume column and sent to next stage.  i.e. green colour shows the input and red shows the calculated field.

 

I want to create lookup or something which help me to calculate below 

if stage =harvest  then volume = 10000 (initial user value)

if stage = primary processing  then volume = 10000*0.4 (harvest(volume)* harvest(sent to next stage)

if stage=further processing = then volume = 10000*0.4*0.5( harvest(volume)* harvest(sent to next stage)*primary processing(sent to next stage).

 

I need help how should I approach to this. 

 

I would really appreciate your reply.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Featured topics

Loading complete