News and Announcements icon

Power Platform CommunityForums Calling Actions from Copilot Studio why SQL query become j...

Calling Actions from Copilot Studio

Unanswered

why SQL query become json? how to parse json into string?

(0) Share

Report

Report

Posted on by zhengtzerlee

21

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

Categories:

Power Automate Flows

Flow Integration

All responses Img

All responses (1)

Answers Img

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Re: why SQL query become json? how to parse json into string?

Hi @zhengtzerlee ,

Please try this

string(body('execute...')?['ResultSets/Table1']?[0]?['changeLaptop'])

Best Regards,

Wearsky

Helpful resources

News and Announcements

Important Update on New Community Platform

Quick Links

Leaderboard

#1

WarrenBelz 138,287

#2

RandyHayes 76,308

#3

Pstork1 63,172

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans