cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kmk
Helper V
Helper V

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

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.

conbinationdatatype.PNG

 

your help will be highly appreciated 

 

1 REPLY 1
ManishJain
Solution Sage
Solution Sage

Hi @kmk ,

 

If you are doing looping and using the fields , try using compose action and specify your inputs with expression. 

 

Thanks

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,107)