cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver I
Resolver I

Parsing data

Dear PA peers--

 

How would I go about parsing this data: ["6 Month","12 Month","Primary (single)"]

 

I just need the data between the " " and stored in a single string. 

 

This is a tuffie for me.

 

Best, JS

2 ACCEPTED SOLUTIONS

Accepted Solutions
Dual Super User
Dual Super User

@wiredupjax 

 

Created an sample for your requirement:

 

Stored the string which you provided in a variable of type Array. Looping thru each item to get individual value:

 

1.JPG

 

Output:

2.JPG

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

View solution in original post

@rsaikrishna helped me nail the final solution! Many thanks

 

For MemberShip Conversion

----> replace(replace(replace(replace(outputs('MembershipType'),'["',''),'"]',''),'"',''),',',', ')

 

final.jpg

View solution in original post

7 REPLIES 7
Dual Super User
Dual Super User

@wiredupjax 

 

Created an sample for your requirement:

 

Stored the string which you provided in a variable of type Array. Looping thru each item to get individual value:

 

1.JPG

 

Output:

2.JPG

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

View solution in original post

@rsaikrishna 

 

Actually, this threw an error:

 

BadRequest. The variable 'varString' of type 'Array' cannot be initialized or updated with value '["12 Month","Primary (single)","Corporate"]' of type 'String'. The variable 'varString' only supports values of types 'Array'.

@wiredupjax 

 

Can you please share the screen shot of your flow? 

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

parse.jpg

@wiredupjax 

 

Before your first action "Initialize variable...", place a compose action and set the value Wellness Progra.. field. 

 

Now, Initialize variable with output from compose action.

 

Share the flow result of the compose and initialize variable actions.

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

parse 2.jpg

@rsaikrishna helped me nail the final solution! Many thanks

 

For MemberShip Conversion

----> replace(replace(replace(replace(outputs('MembershipType'),'["',''),'"]',''),'"',''),',',', ')

 

final.jpg

View solution in original post

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (12,555)