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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,875)