Answered

How to update status based on calculated field powerapps

Like (0) Share

Report

Posted on 21 Apr 2022 02:02:47 by biha

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?

Categories:

Using Apps Using Formulas

All responses (2)

Answers (1)

Verified answer

AsanKani 710 on 23 Apr 2022 at 06:33:29

Like (0)

Report

Re: How to update status based on calculated field powerapps

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 😌.
kylzbaba 182 on 22 Apr 2022 at 21:49:54

Like (0)

Report

Re: How to update status based on calculated field powerapps

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").