Hi @addepallimadhu ,
Here is one approach to the problem. The solution transforms array 2 into a JSON object from where you can lookup the external code using the account code:
This is the expression used in the compose action:
json(slice(replace(string(body('Select')),'},{',','),1,-1))
I'm converting the output of the Select action into a string, then replacing the text "},{" to "," , then using the slice function to remove the "[" and "]". Finally the JSON function converts the JSON "object" (which is still a string) into a real JSON object.
Select 2 is used to produce the required data structure:
The expressions used in Select 2 are:
convertedCode: outputs('Compose')?[item()?['account']]
txType: item()?['txType']
amount: item()?['amount']
Here is the runtime output of the demo flow:
Hope this helps.
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
