Power Automate Retrieve values as a concatenated string from JSON object
Image Source: Shutterstock.com
Power Automate
Jun 12, 2023 10:02 AM

Power Automate Retrieve values as a concatenated string from JSON object

by HubSite 365 about Jon Russell

7x MSFT Certified || Power Platform Consultant, Co-Lead MHFAs, People Champion at ANS #HowAreYou

Citizen DeveloperPower AutomateLearning Selection

The poster, was asking for a value from a JSON array to be extracted and then concatenated into a string.

Power Automate Retrieve values as a concatenated string from JSON object Retrieve values as a concatenated string from JSON object How are you doing? I was on the Power Automate forums today and came across this post: Multiselect choice column in SharePoint returning array using Get item trigger; need to convert this into a string separated by commas.
I thought I would write a quick blog post to explain what I did to achieve the intended result. The poster, was asking for a value from a JSON array to be extracted and then concatenated into a string.

  • First of all, I set up an Instant Cloud flow
  • Then I created a StringValue string variable in an initialize variable step
  • Next, I added a compose action to capture the JSON object from the post on the forums. Note: I came up across an error when trying to save the flow, I needed to add an extra @ sign at the start of the odata.type lines
  • Next, I used the Select action, and pulled out the Value item from theJSON object. In the screenshot below, I am selecting the Ouputs from the dynamic content from the compose

Extracting and Concatenating JSON Object Values

In this example, we explored how to extract values from a JSON object and concatenate them into a readable string using Power Automate. It shows the flexibility of Power Automate in handling and transforming data, making it an essential tool for those working with SharePoint and other platforms. The steps provided are practical and can be helpful for similar tasks involving JSON objects and data manipulation.

Read the full article Power Automate Retrieve values as a concatenated string from JSON object

Learn about Power Automate Retrieve values as a concatenated string from JSON object

Power Automate is a powerful platform for creating automated workflows, and it can be used to retrieve values from JSON objects. In this example, we will be looking at how to retrieve values from a JSON object and concatenate them into a string, separated by commas. To do this, we will need to create a cloud flow and set up an Initialize Variable step. We will then add a Compose action to capture the JSON object from the post on the forums. After that, we will use the Select action to pull out the Value item from the JSON object. Finally, we will use the Concatenate action to combine the values into a single string, separated by commas. With this method, we can easily retrieve values from a JSON object and concatenate them into a single string.

More links on about Power Automate Retrieve values as a concatenated string from JSON object

Microsoft Flow: How to Concatenate Data from JSON Object
Oct 18, 2017 — Solved: I have a REST Web Services Call that is returning data in the following format: { "Id":
Retrieve values as a concatenated string from JSON object
Apr 30, 2023 — First of all, I set up an Instant Cloud flow, then I created a StringValue string variable in an initialize variable step.
Microsoft Flow: How to Concatenate Data from JSON Object
Oct 18, 2017 — What is the best way to do this with a flow? Is there a way to concatenate data over a loop or something? I can't seem to find a way to do it.
How to iterate the ParseJSON output in power automate ...
Jan 30, 2021 — I am parsing that json string through parsejson action with the power automate. Now I want to iterate through the JSON object to verify few key ...
How to concatenate 2 JSON object variables - Claris Community
Just read the data_ex from one and add it to the other. JsonSetElement( $first_var ; "date_ex" ; JsonGetElement( $second_var ; "date_ex ; "" ) ; jsonstring ).
Concatenation functions tips and tricks in DataWeave
In DataWeave, concatenation can be achieved by using the ++ function. However, there are two additional syntax options to concatenate objects and one to ...

Keywords

Microsoft Power Automate, SharePoint, JSON object, Choice Column, Multiselect, StringValue