I am collecting log entries in the Team's chat and after several "Parse JSON" actions I end up with the core "Body" from the log which looks like that:
[
{
"name": "Module",
"value": "<p>NewProductNotification</p>"
},
{
"name": "Message",
"value": "<p>New entity created, but could not find a child Item and cannot send a mail to the Product Owner, sending to CCAddress if applicable...</p>"
}
]
The last mile should be straightforward: Parse JSON once more using the above data as a schema template, select from the parsed body the name and value and use them. It works for the Module but not for the Message
I tried the following method to extract the message in my sandbox without success. I tried to convert the Message to the plain text but I can see as input only <p></p>
How to get the whole piece of the Message and save it as a variable. I want to use it later to save it in the SharePoint list and also convert it to plain text.
When the flow runs...
Any tips?
Solved! Go to Solution.
Hey @Michal
Your message is in the 2nd object [1], not the first [0]. Therefore you are looking for:
body('select')?[1]?['message']
Damien
Hey @Michal
Your message is in the 2nd object [1], not the first [0]. Therefore you are looking for:
body('select')?[1]?['message']
Damien
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
29 | |
27 | |
23 | |
17 | |
10 |
User | Count |
---|---|
65 | |
56 | |
29 | |
27 | |
25 |