web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How to convert this ar...

Power Automate

Unanswered

How to convert this array of objects to a string array

(0) Share

Report

Report

Posted on by cardinalnight

212

I need to convert this:

 "text_2": "[{\"email\":\"ptell@domain.com\"},{\"email\":\"jsmith@domain.com\"}]"

I'm getting this from a:

JSON(collection)

in a PowerApp that triggers the flow.

My ultimate objective is to create SharePoint list items for each email.

I believe that I have to convert the first line of JSON above to a string array, so I can then use a split() function, to add to an array?

Help needed!

Thanks.

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @cardinalnight

Here is the sample flow.

I have stored the input array in compose action in this example:

"text_2": "[{\"email\":\"ptell@domain.com\"},{\"email\":\"jsmith@domain.com\"}]"

Nex, add "Apply to each" action & to covert the input array to JSON write an expression as a input to this action. Expression needs to be written in the expression window as shown below:

json(concat('{',replace(replace(replace(outputs('Compose'),'\',''),'"[','['),']"',']'),'}'))?['text_2']

Add Create item action inside apply to each action block to add the list items in SharePoint list. Here using expression, I am setting email addresses in Title field of SharePoint list:

item()?['email']

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No

Join the conversation