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
(ID ='HPMdb 0000119')
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
Hi @kmk ,
If you are doing looping and using the fields , try using compose action and specify your inputs with expression.
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Check out the new Power Platform Community Connections gallery!