Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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 

 

  • MJain Profile Picture
    2,450 on at
    Re: What data type i can use for combination of string and number: HPMdb 0000119

    Hi @Anonymous ,

     

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

     

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,601 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,942 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow