I have a parse Json that I need to convert the format of the value.
the output of the parse json is :
Hi @noor12
Here is the sample flow.
I have used compose action to store the output of parse json action:
[
{
"BILL_PROFILE_NUM": "2222222"
},
{
"BILL_PROFILE_NUM": "11111"
},
{
"BILL_PROFILE_NUM": "333333"
},
{
"BILL_PROFILE_NUM": "44444"
}
]
Next, add "Select" action to traverse all elements & fetch the values. Pass the output of compose action to "From" parameter as its input.
Click 'Switch Map to text mode':
Enter the below expression in the textbox. Expression needs to be added in the expression box as shown below:
concat('''',item()?['BILL_PROFILE_NUM'],'''')
Finally, add another compose action to get the final output:
concat('(',join(body('Select'),','),')')
Output:
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Share
Report
All responses (
Answers (
15,169
