Data Mapping via Flow

(0) Share

Report

Posted on by PValette

I would like map values in several attributes, for example

0 : Critical

1 : High

2 : Medium

3 : Low

From the trigger, I receive this JSON structure

{

"priority":1

}

and in the flow, I would to transform in

{

"priority":"High"

}

How I can do this with Flow?

Thanks / Philippe

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi PValette,

You may try to use workflow definition language to replace a string with a given string.

Please check the documentation at here:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

For a simple test, I use the following function in a Compose action:
if(equals(triggerBody()['text'],'0'),replace(triggerBody()['text'],'0','Critical'),'')

Hope this could be a reference for you.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
Hugo_baltech 3 on at

Like (0)

Report
Copy link

Link copied!

One way to achieve something similar to a hash table in power automate is to use the *Select* data operation and then access it under 'expressions' like so:

Where the 'Body' variable is given as 'body('Select')[0][string(body('Parse_JSON_-_input')?['priority'])]'.
Running in the following order:

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!
Example:

Expression in Compose 2:

concat( if(equals(outputs('compose')['priority'],0), 'Critical', ''), if(equals(outputs('compose')['priority'],1), 'High', ''), if(equals(outputs('compose')['priority'],2), 'Medium', ''), if(equals(outputs('compose')['priority'],3), 'Low', '') )

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

Was this reply helpful? Yes No