Unanswered

Urgent need help - when a column change .. value to 0not to send the email flow.

(0) Share

Report

Posted on by bbsin

1,994

I have a approval flow1 that when the InvAmount has number (value); it will trigger to the 2nd workflow to send the email

So for the InvAmountApproval flow under rejected is hardcode to 0 ; but it still trigger this below 2nd flow as it has value.

I do not want it to send out the email if the InvAmount is 0 that is rejected.

Thanks

2nd FLow - column InvAmount has been modified - when there is a value

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@bbsin

Which connector you are using?

Was this reply helpful? Yes No
JamesYumnam on at

Like (0)

Report
Copy link

Link copied!

Hi @bbsin please provide more details on where your data is stored and what kind of a column are you trying to track the change in value.
First you may need to fetch a specific row and then get a column and then compare its value of the column using Control action.

If possible, please show the flow that you have created.

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

Hi

okk I have a column for invoice amount when there is value ; using PowerApps to submit with workflow; it is modifying the existing data, it will trigger to send the email once approved

Now I have a problem when the item is rejected, I hard code he amount to 0, as it's a value it still send the email

How to not trigger to send email when the value is 0?

Thanks

Was this reply helpful? Yes No
JamesYumnam on at

Like (0)

Report
Copy link

Link copied!

Hi @bbsin
What are you using to store the data: Dataverse, SP list etc?

Was this reply helpful? Yes No
JamesYumnam on at

Like (1)

Report
Copy link

Link copied!

Please follow and check if this helps:
1. In your powerapp, on submission, you can pass the invoice amount to the flow. should look like this: Flowname.Run(invoiceAmountTxt.Text)
2. In your Flow, you should have "Ask In PowerApps" action. As an output of this action, you can get the invoice amount which you have passed from your app.
3. Using If condition, check if InvoiceAmount > 0. If yes, send the Approval mail, If No, do not send the approval mail.
4. Update the data.

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

Hi @JamesYumnam

The submission is not send directly from PowerApps ..it's using Automate. so don't have the 1) item.
as the sbmission is bit complex. is there any way to change in the automate?

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@bbsin

I think you need to share how your flow is currently structured and explain with screenshots so that we have a better understanding and be able to support you,

Was this reply helpful? Yes No
JamesYumnam on at

Like (0)

Report
Copy link

Link copied!

@bbsin
ok then, based on the data source, I am assuming you have used some trigger similar to "When a row is created,modified or deleted" or "When a row is modified" etc..

Add an Condition action and use is greater than operator. In the Yes action, add your send email action or Approval action. In No, do nothing.
Sample flow using dataverse as datasource (here item is your Invoice column name)

Was this reply helpful? Yes No