You’re offline. This is a read only version of the page.

Power Automate

Unanswered

What data type i can use for combination of string and number: HPMdb 0000119

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Mates,

i want to execute SQL command to get based on filter so using Execute a SQL Query, there i need to filter with a field value

ex: filter in ID field where Id=HPMDB 0000119

SELECT ID,FROM
 Table
WHERE
 (ID ='HPMdb 0000119')
-----------------------
SELECT ID,FROM
 Table
WHERE
 (ID ='@{outputs('Compose')}')

i can get expected values from the first query, but not from the last/next query because its combination of string, number

what is the data type can we use for combination of string/number

yes i also tried taking variable, with string datatype but it throws error since it contains numbers as well.

your help will be highly appreciated

Categories:

I have the same question (0)

All responses (1)

Answers (0)

Join the conversation

Helpful resources