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
Solved! Go to Solution.
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:
Output:
Regards
Krishna Rachakonda
If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking 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. |
@rsaikrishna helped me nail the final solution! Many thanks
For MemberShip Conversion
----> replace(replace(replace(replace(outputs('MembershipType'),'["',''),'"]',''),'"',''),',',', ')
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:
Output:
Regards
Krishna Rachakonda
If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking 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. |
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'.
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 Solution. Marking 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. |
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 Solution. Marking 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. |
@rsaikrishna helped me nail the final solution! Many thanks
For MemberShip Conversion
----> replace(replace(replace(replace(outputs('MembershipType'),'["',''),'"]',''),'"',''),',',', ')
User | Count |
---|---|
89 | |
41 | |
23 | |
20 | |
16 |
User | Count |
---|---|
130 | |
51 | |
48 | |
36 | |
26 |