smallmoney from SQL not allowable for Power Automate flow?

(0) Share

Report

Posted on by Holly_CMS

523

Hi,

I am not sure if the datatype - smallmoney from a field in a SQL table is allowable in the Power Automate? I am running into the error - "Unable to process template language expressions for action 'Condition' at line '0' and column '0': '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.'."

If so, how do I fix this?

Thank you 🙂

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

Michael E. Gernaey 53,960 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Holly_CMS

The issue isn't that you cannot compare money (aka decimal/float) it is that your values are not of the same type. One is a string and on is a number.

Your first Dynamic property are strings, not $$. I mean they may look like it but its not in that format.

So lets convert it to an int and get you going.

But first I need to see an example of what it looks like. Can you please add 1 Compose action above the condition
and put the Dynamic Property there, run your flow, it will fail, but you can grab the the Output of the compose to share what it looks like.

Or if you want to take a picture of what it looks like in SharePoint.
I really want to make sure there is no $ sign or currency symbols and its just like 12000.12

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Holly_CMS 523 on at

Like (0)

Report
Copy link

Link copied!

Here you go. Originally, the column was in a single line of text and then I flipped to number...

Was this reply helpful? Yes No
Verified answer

Michael E. Gernaey 53,960 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @Holly_CMS

super simple then

You need to wrap your Dynamic property in the int expression.

1. Remove the Dynamic property on the left
2. Click in the Space
3. when the pop up shows, click the Expression tab
4. type int() (no spaces between ( and )
5. without close the popup click the Dynamic property tab
6. Click in between the two ( and )
7. scroll to your dynamic property, click it, it will insert itself inbetween the ( and )
do that for both

Done

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Holly_CMS 523 on at

Like (1)

Report
Copy link

Link copied!

Ok I got to the expression part done >>

int(items('Apply_to_each')?['cost_estimate'])

but which left of the action are you referring to in step 1?

This?

Was this reply helpful? Yes No
Michael E. Gernaey 53,960 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Holly_CMS

yeap in your Condition since thats where the error is from.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Holly_CMS 523 on at

Like (0)

Report
Copy link

Link copied!

Ok That's what I thought - I am testing it right now. BRB 🙂

Was this reply helpful? Yes No
Michael E. Gernaey 53,960 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Holly_CMS

as long as no values are blank or null (the costs estimates) it should be fine, if some can be null or blank then we need to change it again, you didnt say so I just me'hd t lol

Was this reply helpful? Yes No
Holly_CMS 523 on at

Like (0)

Report
Copy link

Link copied!

hmmm....??

Was this reply helpful? Yes No
Holly_CMS 523 on at

Like (1)

Report
Copy link

Link copied!

I figured out the error - Both are working now! 🙂
Thank you!

Was this reply helpful? Yes No