Share
Report
32Hi Team,
I've created a cloud flow to trigger when an email arrives.
Email Json output
[
{
"PID": "ABC10012.com",
"Status": "Running"
},
{
"PID": "ABC10012.com",
"Status": "Running"
},
{
"PID": "ABC10013.com",
"Status": "Stope"
},
{
"PID": "ABC10019.com",
"Status": "Stopped"
}
]
I want to Look up with a Dateverse Table which is custom created.
"PID": "ABC10013.com",
"Status": "Stope"
},
{
"PID": "ABC10019.com",
"Status": "Stopped"
}
]
I want to Look up with a Dateverse Table which is custom created.
Table Name: PID_ConfigTable
Columns
Process: Process1
Machine: [{"Machine":"ABC10012.com","connectionreference":"1234567abcf"}, {"Machine":"ABC10013.com","connectionreference":"abc123456788"}]
What is the best way to compare both the Email and Dataverse to have an output generated as below?
Output
Process: Process1
Machine: [{"Machine":"ABC10012.com","connectionreference":"1234567abcf"}, {"Machine":"ABC10013.com","connectionreference":"abc123456788"}]
What is the best way to compare both the Email and Dataverse to have an output generated as below?
Output
Process1
Total machine = 2
Total machine = 2
Total not Running = 1
% Not Running = 50%
If you can guide on what is the best possible solution for me to start?
Thanks,
Categories:
I have the same question (0)
All responses (
Answers (
