web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

How to store data in Object of array format in power automate?

(0) ShareShare
ReportReport
Posted on by
Hi All,
 
I have a power automate and I have declared an array variable, in this array variable I am appending two attribute from the list result of opportunity entity.
 

[
"OppUrl":"URL",
"OppID":"Opportunityid"
]
but result is showing like:
[
    "\n[\n\"OppUrl\":\"URL\",\n\"OppID\":\"ID\"\n]\n",
   "\n[\n\"OppUrl\":\"URL\",\n\"OppID\":\"ID\"\n]\n",
     "\n[\n\"OppUrl\":\"URL\",\n\"OppID\":\"ID\"\n]\n",
   "\n[\n\"OppUrl\":\"URL\",\n\"OppID\":\"ID\"\n]\n",
]
I need the result like :
[
{
  "OppUrl": "url",
   "OppID": "123"
},

{
"OppUrl": "url",
   "OppID": "345"
},

{
"OppUrl": "url",
   "OppID": "678"
}

]
 
 
 
How can I achieve the result like above JSON?
 
 
 
 
I have the same question (0)
  • Suggested answer
    Tom_Gioielli Profile Picture
    3,084 Super User 2026 Season 1 on at
    There might be a few things wrong here, so I'll start at the beginning. If you want to end up with an array of values from a query in Power Automate, you can do the following.
     
    • Trigger your flow however needed (schedule, manual, etc.)
    • Dataverse - List Rows action
    • Data Operation - Select
      • This is where we are going to build up our array of results
      • From: value(list of items)
      • Map: Your data fields
    At this point, you should be able to then Parse the outputs of the Select operation if you want to do some sort of work on the array or do whatever you need with it. Here is a screenshot of the whole thing.
     
    The outputs from the above flow in my demo environment was as follows.
     
    [
      {
        "Opportunity ID": "9b9ed419-af30-ee11-bdf3-000d3a14bdde",
        "Opportunity Name": "10 orders of Product SKU JJ202 (sample)"
      },
      {
        "Opportunity ID": "9d9ed419-af30-ee11-bdf3-000d3a14bdde",
        "Opportunity Name": "10 orders or Product SKU AX305 this summer (sample)"
      },
      {
        "Opportunity ID": "9f9ed419-af30-ee11-bdf3-000d3a14bdde",
        "Opportunity Name": "Some interest in our JJ line of products (sample)"
      },
      {
        "Opportunity ID": "a19ed419-af30-ee11-bdf3-000d3a14bdde",
        "Opportunity Name": "Office 365 Services"
      }
    ]
     
     
    A few other random things I noticed in your flow.
    • the column with schema 'opportuntiyid' is the GUID of the record, like seen in my outputs. You might be looking for some other custom ID used in the system, so you will want to make sure you grab the correct schema name
    • 'Oppurl' is also not a result of the outputs in List Rows for Dataverse that I'm aware of, so if it is a custom field you are missing a prefix or something on the schema name
    • If you are going to manually build up the array instead of use the Select action, don't put your variables inside quotes. This will cause the flow to take the values as literal strings instead of the merged value
     
    I hope this helps. I think you are close, just a few extra steps throwing you off. If this answer helped, please consider marking as verified.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 180 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 123

#3
CU11031447-0 Profile Picture

CU11031447-0 100

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans