Unanswered

Insert comma between two strings- json object

(0) Share

Report

Posted on by cgrant88

Hi I'm a beginner in Power Automate and I am pulling my fields from a connector that uses json. If two items are returned it puts them together like Donald DuckMickey Mouse with no space or comma in between them. I'd like the output to appear as Donald Duck, Mickey Mouse.

The condition has this: length(outputs('Get_each_gift_details')?['body/soft_credits'])

Then I get the constituent ID for the person and then the Name of the person.

The json is like this:

"soft_credits": [
{
"id": "123456",
"amount": {
"value": 10
},
"constituent_id": "0010",
"gift_id": "8888"
},
{
"id": "123333",
"amount": {
"value": 10
},
"constituent_id": "0011",
"gift_id": "8888"
}
]

Thanks for any help!

Carol

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @cgrant88

Where is the name in that JSON? Not clearly understood your requirement.

If you want to put comma between two different strings and combine it then use contact() expression

eg: concat('A', ',', 'B')

will output as A,B

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Hi @cgrant88 ,

The reason is you are appending the Names to a string variable. To achieve the goal, initialize an array variable and append all the Name to it within the loop, add a compose operator below the for each loop with its value set to below expression:

join(variables('ArrayVariableName'), ',')

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
cgrant88 8 on at

Like (0)

Report

I've tried appending this to an array variable and it didn't work. Here is the flow:
What happens is it accumulates everyone's soft credit names not just for that gift.
Gift 1- Mickey Mouse
Gift 2- Donald DuckDaisey Duck
Gift 3- Goofy Dog
My ending Compose with a join is: Mickey Mouse, Donald DuckDaisey Duck, Goofy Dog
All I want is for Gift 2 to be Donald Duck, Daisey Duck if there is more than one listed.
The rest of the flow looks to see if there are gifts then if yes it pulls in other information about that one gift and loops through them.

I'm not sure who marked this as a solution and I'm also not sure where all the other comments are when I was working with Expiscornovus.

Was this reply helpful? Yes No