convert look up array result to comma separated values

Mothe Sriram 0

I need to get the look up array format result into comma separated values.

Ex : { "count": 652, "value": [ { "Tracked_Item_Id": 7206574 }, { "Tracked_Item_Id": 7206575 }, { "Tracked_Item_Id": 7205950 }]}

Expected output : Value :[7206574 ,7206575 ,7205950 ]

Mothe Sriram 0 Reputation points

2024-04-06T17:02:03.28+00:00
I tried to use join and replace functions to get the result in desired format but its not working.

@replace(replace(join(activity('LKP_TS_LOGNOTE_ALL_Tracked_Item_Ids').output.value, ','), '{"tracked_item_id":', ''), '.0}', '')
Richard Swinbank 522 Reputation points MVP

2024-04-07T16:27:25.4733333+00:00

Can you add some information about your use case? From your example it appears that you're trying to extract a set of values into an array containing only Tracked_item_id values. What will you use the array for?
phemanth 10,325 Reputation points Microsoft Vendor

2024-04-08T09:29:26.1533333+00:00

@Mothe Sriram We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Your answer