Alarm and auto reject if number is more than budget

[ShineTan123]

Hi Community,

I have an app to flow the approval. And there is a step that the requestor to update the actual cost, and then the request will flow to the approvers. Now I want to add the control gate to reject if the actual cost is more than the budget. How should I do?

The actual cost updated screen is based on a table, and there is a field for budget. 

[WarrenBelz · Accepted solution]

Hi @ShineTan123 ,

Assuming those controls are on a Form

If(
   Value(ActualPaidTextBoxName.Text) > ThisItem.Budget,
   DoRejectionHere,
   SendApprovalHere
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[ShineTan123]

Hi @WarrenBelz ,

Yes, this is for a form which is coming from a gallery. But how should I code this together?

[WarrenBelz]

Hi @ShineTan123 ,

You really have not given me enough information to start on the process after that. The rejection could be a message (pop-up/visible Label/Notification) - or do you want to populate something. The approval is whatever you are doing now.

[ShineTan123]

Hi @WarrenBelz ,

My apology. 

I want there will be a pop-up error message to notify the requestor the actual cost is more than budegt, and this will also stop the requestor to submit the request. If so, how should I code?

[WarrenBelz]

@ShineTan123 ,

Just use Notify() - that is probably the easiest

Notify("More than budget",Error, 5000)

If you want a pop-up, you need to set a Variable to true, then have the Visible of the pop-up as that Variable - you then also need an X on this setting the Variable to false to hide it once viewed).

[ShineTan123]

Hi @WarrenBelz ,

This formula is objecting on Form-Item, right? Could you guide me with more details? I am still not familiar with the Apps.

Thanks!

[WarrenBelz]

Hi @ShineTan123 ,

I am happy to correct any code you attempt and cannot get right. What have you attempted with the code I posted ?

[ShineTan123]

Hi @WarrenBelz ,

I think I didn't get it right, I put the formula into the Form-Item, it's not working. I think I did it wrongly, how should I correct that?

Form-Item is originally from Gallery.Selected.

[WarrenBelz]

@ShineTan123 ,

That really should be on the same control you submit the form with, but I think you need to take a step back here and understand what the various functions do. I am happy to help with code, but I cannot teach you how to use Power Apps.