Power Platform Community Forum Thread Details

Converting SQL Get Rows data to Integer for comparison against Excel data

Hi everyone,

I have a flow that checks a field value in an Excel table against an SQL database for the matching value, and then takes all the row data from that SQL record and attaches it to the Excel table row.

However, my condition statement in the flow always returns as false because the data type from SQL and the Excel file dont' match. In talking through this online someone had mentioned that I need to wrap the condition check with an expression to convert the Excel value to an integer, provided me with the expression to enter to the condition statement, but Power Automate returns this expression as invalid.

Looking for insight on how to get the data type to match so that the comparison the condition statement is doing is valid and pulls in the required data.

The part of my flow that this pertains to looks like this;

Screenshot 2022-11-06 172345.png

The person talking me through this gave me this expression to enter to the right of the IS EQUAL TO statement to convert the Excel value to an integer to match the SQL data and therefore make it possible to compare and correctly return the other row field data:

int(items('Apply_to_each_2')?[Registration ID])

However, I tried to put this into the field and it returns with Invalid Expression.

How do I solve for this? This is the last piece of a very complicated flow puzzle and I'd love to solve this once and for all.

Thank you!

Categories:

Business Process Flows

Quick Links

Leaderboard > Power Automate