Hi,
I am having difficulty with sql query when trying to implement in copilot studio, which part i did mistake on?
[1] simple SQL query result as below, i just want the "1" as result, no issue on SQL
[2] on power automate, I execute the same query
result is int, so i convert to string
[3] when in copilot studio bot, it weirdly become json, Zzzzzz.. why
may i know how to only getting the "1" in "changeLaptop" column?
i must have miss something, SQL query should be direct simple ><
thanks a lot
Lee
Hi @zhengtzerlee ,
Please try this
string(body('execute...')?['ResultSets/Table1']?[0]?['changeLaptop'])
Best Regards,
Wearsky