Answered

Approval Condition based on SharePoint List column value

(2) Share

Report

Posted on by Liam-Billington

Hi All,

I'm trying to build a flow which connects to a List on our sharepoint site which I have designed as a Budget Approval list.

The idea is that when a user enters a budget approval request for an item they need to buy, the flow should look at a specific column (ItemValue) and if the value is Greater Than £150.00 then it should follow the approval route, otherwise if less, should auto-approve the item and notify the requster.

I've built most of the flow, but keep getting stuck at the actual condition to trigger the Yes / No section based on the ItemValue

Not sure if worth noting as well, the ItemValue column is a calculated column based on 2 other columns, Net Value + Net Freight

Ive tried:

@greaterOrEquals(triggerBody()?['ItemValue]'), 150.00))

And similar variations to the above but all come back with an error sayng The Expression is invalid

For some reason adding the Dynamic Field for ItemValue in the "Choose a value" does not give me the less than or greater than options, but other fields do.

Any ideas?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

v-bacao-msft on at

Like (0)

Report

Hi @Liam-Billington ,

Could you provide more details about ItemValue field?

I want to know the type of it, as well as the details of the other two fields that make up its value.

I assume that the type of Calculated column is Currency, and the other two fields are Currency, as below:

Condition automatically recognizes the field type corresponding to Dynamic content. If it is not a Number or Date etc. , the option "Greater than" will not be displayed.

Since you are comparing values, you could first use float() function to convert the field value to a value so that you can compare it using options like greater than.

Image reference:

Please take a try.

Best Regards,

Was this reply helpful? Yes No
Liam-Billington 18 on at

Like (0)

Report

Hi @v-bacao-msft

Thanks for your response:

You're quite right the ItemValue field is a Calculated Column with a currency value, which totals the value of 2 additiona fields "Net Value of Item" (Which is a standard Currency Field) and "Net Value of Frieght" (which again is another standard Currency Field)

ItemValue is Calculated with formula =[Net Value of Item]+[Net Value of Freight]

I tried using the float() function but this also does not seem to work

When I entered the expression i immeditaly got an error saying the Expression is not valid - clicking update again, inserted the expression and gave me the greater or equals to options, but running the flow gave a parameter error.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @Liam-Billington ,

Thank you for your reply.

Could you provide the result of the excution of When a new item is created?

I want to know the value and type of this ItemValue field output.

Best Regards,

Was this reply helpful? Yes No
Liam-Billington 18 on at

Like (0)

Report

Hi @v-bacao-msft

The output looks like this - which is correcly calculating the value of the Net Value of Item and Net Value of Freight
Hope this helps.

Many Thanks
Liam

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (1)

Report
Hi @Liam-Billington ,

Thank you for your reply, but very strange, this Expression is work for me here.

You could try the following methods to make changes.

Use Compose to enter this Expression first, as below:

Or you could try to convert this value to a string and then to a float type.

The above methods are working here for me. Please try a few more times.

Best Regards,

Was this reply helpful? Yes No
Liam-Billington 18 on at

Like (0)

Report

Hi @v-bacao-msft

Can confirm that the Compose expression seems to be working and the flow is now working as it should be have tested several times and all going through correctly.

Thank you very much for the assistance.

Liam

Was this reply helpful? Yes No