Answered

get data using get rows in sql server power automate

(0) Share

Report

Posted on by hninyuaung

Hello,
I want to get rows (sql server) action to get data in power automate. Output column data is
"X_Intake_Forms": "Floor: 09\n\nUnit: 04\n\nBuilding Name (Optional): Fernwood Towers"

I want to get data from this column like
Floor is 09
Unit is 04

Building name is Fernwood Towers
How can I do it?

Thanks,

All responses (2)

Answers (1)

hninyuaung 42 on at

Like (0)

Report

Re: get data using get rows in sql server power automate

Hello Yueyun Zhang,
It is working.
Thanks
Verified answer

v-yueyun-msft on at

Like (1)

Report
Re: get data using get rows in sql server power automate

Hi , @hninyuaung
According to your description, you want to convert the "Floor: 09\n\nUnit: 04\n\nBuilding Name (Optional): Fernwood Towers" to :
Floor is 09
Unit is 04
Building name is Fernwood Towers

Here are the steps you can refer to :
(1)This is my test json to test by creating in the compose action:
json('{ "body":{}, "value":[{ "X_Intake_Forms" : "Floor: 09\n\nUnit: 04\n\nBuilding Name (Optional): Fernwood Towers" }] } ')
(2)We can use this code to split this Text by '\n\n':
split( outputs('Compose')?['value']?[0]?['X_Intake_Forms'], decodeUriComponent('%0A%0A') )

(3)Then we can use the "Select" action to convert this array to the new array we want to like this:
concat(split(item(),':')[0],' is',split(item(),':')[1])

The result is as follows:

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,
Yueyun Zhang