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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Dynamically map json c...
Power Automate
Answered

Dynamically map json column with value from dataverse list rows

(1) ShareShare
ReportReport
Posted on by 112

Hi all,

 

I'm trying to use a value from the Dataverse List rows action (image2) in the output of a JSON (image1) based on the 'ClientNo' field.

Actually a kind of filter in the select action (image3) that I now use for a batch create via an http request where 'Client no' = 'vgpa_name'.

 

Is this possible and how can I do this dynamically without creating an apply to each?

image2.jpg
image3.jpg
image1.jpg
Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @RobMolenaar 

     

    If you just want to get the first index then use the below as expression

     

    body('Select_Keys_Active_Customers_Dataverse_2)?[0]?['vgpa_customerid']

     

    Thanks

  • RobMolenaar Profile Picture
    112 on at

    Thank you for your reply @abm ,

    I now get the same guid in every record. This must be dynamic, based on the 'Client number' field. I tried to explain it with an image.

     

    RobMolenaar_2-1713270366352.jpeg

     

  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @RobMolenaar 

     

    If want that to be dynamic in next step should be Select action step and add that as an expression

     

    item()?['vgpa_customerid']

     

    Could you post your flow mappings as in one screenshot. Its easier to see all in one screen.

     

     

    Thanks

  • RobMolenaar Profile Picture
    112 on at

    The problem is that the customerid does not exist in the JSON and item()?['vgpa_customerid'] does not work.
    The ['vgpa_customerid'] is in Dataverse and I want to retrieve it using the Client number.

    Is this screenshot good?

    RobMolenaar_0-1713277849269.jpeg

     

  • Verified answer
    RobMolenaar Profile Picture
    112 on at

    Hi, 

    I have found the solution. I filled in this formula to get the guid of the customerid: outputs('Compose_Reformat_Active_CustomerNo_to_single_JSON_object')?['Clientnr']?['vgpa_customerid']

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 Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard