Power Automate Problem Description

I need help creating a Power Automate flow that is triggered by a button in an admin application in Power Apps (Submit button). I am currently working in a 90-day trial environment.

📌 Background:
I have created a Power Apps system consisting of two applications:

Admin App: Used by an admin to create and send surveys to different departments. Here, the admin can choose which departments should receive the survey.
User App: Used by users to respond to the surveys that are sent out.

I want that when the admin sends out a survey from the Admin App, a notification should be sent to the selected departments via their respective Microsoft Teams channels.

📚 My Dataverse Tables:

Departments: This table lists all available departments.
SurveyDepartments: This table stores the departments that the admin has selected to send the survey to.
Survey1: This table stores the surveys created by the admin.

💡 What I need help with:

How to make Power Automate understand which departments were selected from the Admin App.
How to send a message to the correct Teams channel based on the selected departments.
How to properly set up Apply to each and Condition to compare the selected departments against those stored in SurveyDepartments.

I am unsure whether I should use Power Automate or Dataverse methods to achieve this, so all suggestions are welcome, i would love a step by step guide. Also I havent published my apps yet.

Thank you in advance for any help!

Categories:

Licensing

Hi @AW-24031733-0

Hope to help you.

Some feedback. Its a normal thing here and I try my best to educate people on how to post, not just answer them as otherwise we will skip you as its too much work to pull the information out.

In your post, you do not explain in a simple way what you are trying to do. unfortunately, you do not mention anything about the app even using Power Automate anyway, you just go right to questions

In the future, write your question first with a business process focus. Then tell us how you tried to implement it and what question/issue you have and share pictures it will make it much easier :-). I know you have pictures, unfortunately they are not usable. I dont know if you checked them after but :-( its an issue that I think is the platforms issue not yours but many times they dont even get past the scans bleh :-)

You wrote

What I need help with:

How to make Power Automate understand which departments were selected from the Admin App.
- How and why does the admin app even use Power Automate?
How to send a message to the correct Teams channel based on the selected departments.
- Send it from where? From the admin App itself? As you said thats what does this or from Power Automate.
How to properly set up Apply to each and Condition to compare the selected departments against those stored in SurveyDepartments.
- Cannot answer because I do not see your flow, how your data is linked, etc.

So let's try :-) it differently

But from the App, if the App is using Power Automate to send the notification???

1) You can pass in a comma separated list of either a) the GUIDs for the dataverse rows

2) You can pass in data that represents one of the columns there, that you can filter on in the Flow.

3) Have to app create the email semicolumn concatenated string of all the departments to get it :-) and pass that to PA

4) Have the App send the notification and skip power automate altogether :-)

I can help with any of these

If you do #3 or #4 you shouldnt' have to do any looping as you can simply do nothing in PA (#4) or in the To for the email, just put the string passed to you from the App

Now since (again this is why its so important to explain not what you built but the business process I wrote all that to realize you meant teams)

Email or teams doesn't matter.

You can still use the App or PA.

What you need however, is to store the Team channel name in the Department table. When the App does its thing and selects them, you can again grab their respective channel name, send a comma separated string.

Then in PA add a split(input property)

then you will loop through the names of the channels and be able to easily put your chat message in :-)

Your last question would be answered in the above but happy to help as you go along

If this helps you please Mark as Such

After we can continue to help you build it up, or if you already worked on it but have questions let me know

Thanks!!

Quick Links