Hello,
I have an array that structured as a list of dictionaries (that act as rows) and I am trying to use the Filter array such that it will only grab elements (rows) where the key (column) equals certain value. Any ideas?
Background: Creating a flow to send email to individuals with records that they are assigned to. Ultimately would later create an HTML table from the filtered array to be placed in the email.
Below is the Code View of the filter array (Distinct_Email is a value):
{
"type": "Query",
"inputs": {
"from": "@outputs('Compose_ListOfRecords')",
"where": "@equals(outputs('Compose_ListOfRecords')?['[Email Column]'] , outputs('Distinct_Email'))"
}
}
EDIT:
I have included a screenshot of the flow (at the top there's another run query action for Hire Anniversaries).
- It query two datasets from a PBI report, one for the distinct managers (Mgers) and another for their employees whose birthday is coming up (EE_Birthday) & whose hire anniversary (EE_HireAnni) is coming up. So a total of 3 different queries
- For each distinct manager, I want to filter the dataset such that manager email field in the EE_HireAnni matches with the distinct manager's email (and I want to do the same for EE_Birthday).
- Compose grabs current item, and Compose 1 grabs the value (manager's email) - wonder if that can be condense into 1 action.
- Then I would like turn each results into a HTML table that I can put both in the same email (two separate tables) and then email to that manager
