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
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,357)