web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Data Mapping via Flow

Power Automate

Unanswered

Data Mapping via Flow

(0) Share

Report

Report

Posted on by PValette

6

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:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

v-yamao-msft on at

Like (0)

Report

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

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

Join the conversation