Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

how to extract the value using lookup

(0) ShareShare
ReportReport
Posted on 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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 17

#2
mmbr1606 Profile Picture

mmbr1606 15 Super User 2025 Season 1

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics