cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
biha
Regular Visitor

How to update status based on calculated field powerapps

Hi, I need help on how can I update the status for a calculated field, for example, my calculated field must be more than 50 then the status will display or update to pass otherwise it will display fail. 

 

Ex:

Total>50 = pass

Total<50 = fail

How should I update the data if I want it update on my form status?

1 ACCEPTED SOLUTION

Accepted Solutions
AsanKani
Skilled Sharer
Skilled Sharer

Hi @biha,

You are said want to update your form status. So, I think you are using submit form method.
So, Simply your text box filed to put below coding like..

You are said more than 50 only pass. I guess, 50 & above pass. My guess right means use below formula in your text filed in your submit form

If(Value(TotalMark.Text)=>50,"Pass","Fail")

My guess is wrong and you need only above 50 only pass means use below formulae

If(Value(TotalMark.Text)>50,"Pass","Fail")

I hope now you got the solutions.

Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up/Like it's make me a smile 😌.

View solution in original post

2 REPLIES 2
kylzbaba
Resolver I
Resolver I

I am not exactly sure but I'll give solutions to the two things I think you're asking for.

 

To update a certain field until it gets to a certain value.

 

On the onstart, set the value of a variable

Set(various, 0)

Then whenever an action is taken that needs to update that variable,

Update({varCount: varCount + 1})

So when the action runs the count is updated till you hit your desired result.

 

As for updating a field based on another.

Initialize another variable.

Set(varStatus, Blank())

 

Since it's a calculator field so the onchange property of I'm guessing a text input field you'll write an if statement. If(value(textinput.text) = 50, Set(varStatus, true), Set(varStatus, false))

 

Then set the visible property of the field to varStatus. Thus if the value 50 is reached, it sets to true and the field becomes visible. 

 

 

Also this works for the situation where you want to patch a value based on the value of another filed

 

On the default property of the new field, write the if statement

 

If(value(calculatedfeild.text) > 50, "Pass", "Fail").

 

 

 

 

 

AsanKani
Skilled Sharer
Skilled Sharer

Hi @biha,

You are said want to update your form status. So, I think you are using submit form method.
So, Simply your text box filed to put below coding like..

You are said more than 50 only pass. I guess, 50 & above pass. My guess right means use below formula in your text filed in your submit form

If(Value(TotalMark.Text)=>50,"Pass","Fail")

My guess is wrong and you need only above 50 only pass means use below formulae

If(Value(TotalMark.Text)>50,"Pass","Fail")

I hope now you got the solutions.

Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up/Like it's make me a smile 😌.

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

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.

<
Users online (4,416)