Dynamically map json column with value from dataverse list rows

(1) Share

Report

Posted on by RobMolenaar

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?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
RobMolenaar 112 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
RobMolenaar 112 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

RobMolenaar 112 on at

Like (1)

Report
Copy link

Link copied!

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']

Was this reply helpful? Yes No