I have a fairly simple query: I am trying to email different branch managers across the business the table that has details of their jobs as well as the contract value for their job. I know that I can possibly do that by creating filter button for each
Jobs.xlsx (17.2 KB)
of the branch managers and emailing them, but I would like to know if there is a way to directly email all the managers the table with relevant job information using a click of the power automate button. The problem occurs when I edit the Power Automate button, I select the 'Email from PBI data dynamically, and it directs me to the ‘Apply to each section’ so that PBI data is selected in ‘select an output from previous steps’. What this does is that instead of emailing the table containing list of jobs to managers, it instead emails each data item in the table ‘jobs in this case’ to the managers. Is there a way that i can email the entire table to each relevant manager having all the jobs relevant to them listed?