Answered

Ectracting values, "userDefinedFields"

(1) Share

Report

Posted on by WilliVev

Hi,

I have built a flow where I managed to extract values from "userDefinedFields" so that I can send email to emailadresses coming from "Epostadresse mottaker av egenkontroll" (a user defined field). I want to send different emails to the different adresses, and I want to build the body of the email using some of the other user defined fields.

So I have tested it, and it worked - until I changed a value (text basically) in the system where the data comes from.

So I am using indexing (hardcoded index...or something?) to get the values using a expression like: items('Apply_to_each')?['data']['userDefinedFields']?[2]?['value']

This expression did extract the email adress, because "Epostadresse mottaker av egenkontroll" was the third user defined field in the data. But when I changed some text in one of the fields, the result attached showed that the user defined field "Epostadresse mottaker av egenkontroll" now was number two.

So the order of the fields are not set or consistent.

Is there a way to extract these values based on the name of the user defined field, and not using [0] og [1] or [2]?

All responses (3)

Answers (1)

abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Ectracting values, "userDefinedFields"

Hi @WilliVev

Yes in your case body is an array so it must be inside a loop. Glad to hear that all sorted and thanks for accepting the solution.

Thanks
WilliVev 14 on at

Like (1)

Report

Re: Ectracting values, "userDefinedFields"

Hi @abm ,

Thank you! I first created three different loops, but I soon discovered that I could not acess all user defined fields outside the loop to send a emai. So i did what you suggested x 3, for the three fields, inside one loop. Works perfectly together with the send email action now.

Thanks again!
Verified answer

abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Ectracting values, "userDefinedFields"

Hi @WilliVev

Map that Userdefinedfields in a compose then use a filter array to extract the desired value. Here is an example.

Above use expression item()['name']

Above expression is as follows:

outputs('Filter_array')?['body']?[0]?['value']

Thanks