I am building an automatically triggered flow for approvals. I’d like to get the email address from a sharepoint list. This list consists of two columns. Column 1 contains the department and column 2 the email address. The flow should get the email address by the department in column 1.
The reason why I am doing this is to host variable email addresses to static departments easily. Because some colleagues are not familiar with MS flow. They should change email address in the list and the flow adopts it.
hi @Fuxx what you can do is create a condition no manage the data that you are getting from the sharepoint list.
But if you are trying to just see some change in a certain column and the get just that change. This is not possible in PA yet.
You can leave it as idea: https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/MPAIdeas
I am a bit confused. So the flow should be like that:
It’s triggered when a item was created in a SP library called “disposals”.
Then it should get the email address from a list called “approval instances” with the column “department” and column “email”. The email should be get by department. The values in department stay constant, but the assigned email will change from time to time.
Then there is the approval function which should get the email from previous step.
Sorry if my first post was not detailed enough.
@Fuxx mmm I don't know if I get your example but see this is what I understand.
In this example I have 1 list that starts my flow.
Another in where I have my departments and approvals emails
Then I use a condition to select just deparment that are in the list 1 and compare wuth the list 2 deparments
so if the deparment that my triggers is eq to some deparment in list y start an approval
The approval section use the dynamic content that has the email that belongs to the deparment that was equals in the condition part.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.