Approval Workflow

(0) Share

Report

Posted on by SK_Tan

Hi,

I have an approval workflow like this:

1. X approves the request and updates SharePoint list with approved value;

2. If the said amount > 100,000, it goes to Y for approval; if < 100,000, proceed to next step

Any idea how to build the flow?

Earlier on I put up a condition: Amount field (when an item is created) > 100,000 and it shows the following error msg which I suspect the said field was empty at the point of item creation (value only inputted by X later):

Unable to process template language expressions for action 'Condition_3.1' at line '1' and column '2856': 'The template language function 'greaterOrEquals' expects all of its parameters to be either integer or decimal numbers. Found invalid parameter types: 'Null'.'.

Any quickround on this?

Thanks in adavance!

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

Rahber 1,935 on at

Like (0)

Report
Copy link

Link copied!

I believe its because the variable you are checking is getting a null value. Can you initialize a Integer variable and set it with amount value and then in your condition you use the variable to check if its greater than the threshold.

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,
Rahber

Was this reply helpful? Yes No
SK_Tan 98 on at

Like (0)

Report
Copy link

Link copied!

Hi Rahber,

Thanks for your prompt response.

I tried and I got the following error msg:

The variable 'CL' of type 'Integer' cannot be set to null or empty value.

I do not think it's the integer issue.

1. Before this, I tried earlier on to create an item with the value filled and the flow works.
2. Only when I create an item without the value pre-filled (because the value only populated by X at later stage), the flow failed.

Was this reply helpful? Yes No
Jronash 827 on at

Like (0)

Report
Copy link

Link copied!
Check out the coalesce() function, in expressions. It allows you to provide it with multiple values, and it will return the first one that is not null.

In your case, you can use it to provide a default value in the situation where your Amount is null. It would look something like this:
coalesce(something['Amount'], 0)

This would return the value of Amount, unless it is null. In that case, it returns zero.

I don't know how to reference your actual Amount variable since I don't know how your data is organized. You should be able to select it from dynamic content when you reach that part of the expression.

Was this reply helpful? Yes No
SK_Tan 98 on at

Like (0)

Report
Copy link

Link copied!

HI,

Thanks for your help.

It doesn't work. So in my test person X inputted 120000 in SharePoint list and it should flow to person Y for approval (YES branching)). It end up in the other branching (NO branching) instead. I guess the coalesce still get the first value when the item was first created. I would need the condition to take the value last inputted by person X.

Please see below my flow and test results:

Was this reply helpful? Yes No
Jronash 827 on at

Like (0)

Report
Copy link

Link copied!

Can you post your full coalesce expression?

Was this reply helpful? Yes No
SK_Tan 98 on at

Like (0)

Report
Copy link

Link copied!

It look like this:

coalesce(triggerBody()?['Credit_x0020_Limit_x0020_Approve'])

Was this reply helpful? Yes No
Jronash 827 on at

Like (0)

Report
Copy link

Link copied!
Ok, change it to this:
coalesce(triggerBody()?['Credit_x0020_Limit_x0020_Approve'], 0)

Next, for troubleshooting, create a Compose action before your Condition 3.1 block. In the compose block, put this expression:
triggerBody()?['Credit_x0020_Limit_x0020_Approve']

This will allow us to check the run history and make sure that the trigger value is what we think it is.

Was this reply helpful? Yes No
SK_Tan 98 on at

Like (0)

Report
Copy link

Link copied!

Hi,

It didn't work.

I copied and paste and I got this error msg instead:

Unable to process template language expressions for action 'Condition_3.1' at line '1' and column '2855': 'The template language function 'greaterOrEquals' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'.

Was this reply helpful? Yes No
Jronash 827 on at

Like (0)

Report
Copy link

Link copied!
Well, that's a more helpful error. It's failing because one of your values is a string, and the other is an integer. They need to be the same type for Automate to be able to compare them.

I'm assuming that your trigger is returning the Credit Limit Approve as a string, not an integer. So we can tweak our expression slightly to convert it to an integer.

coalesce(int(triggerBody()?['Credit_x0020_Limit_x0020_Approve']), 0)

Did you also create a compose action before the condition with this formula?

triggerBody()?['Credit_x0020_Limit_x0020_Approve']

When you look at your run history, does it have the value that you expect? (The Credit limit Approve value)

Was this reply helpful? Yes No