Power Platform Community Forum Thread Details

I am comfortable with simple Forms/Flow creations, but having difficulty with a current project. Work in a no-tech job and trying to automate processes for my Dept to ease the workload and reduce errors.

Need: A Flow that uses Form Data to write Data to an Excel table and send out email notifications. What I am having an issue with is the best way to create the form and/or flow. This will be used for redeploying resources from one sector to another. The form will hold up to 5 resources, possibly all from the same sector or multiple sectors, and redeploy them to another sector or sectors. I would like to ensure that the email notifications that are generated group the information appropriately and only send the notifications to the affected sectors. For instance, if multiple units from Sect 1 are redeployed to Sect 2 while also a unit from Sect 1 is going to sect 3. It sends one email to Sect 1 with the total data, and one email to Sect 2 and one to Sect 3 with their respective info. I am at a loss for how to do this without a TON of if/then statements. This seems it would be the case if the flow was reading the info directly from the form or reading it from the excel after it was written.

I am open to a PowerApps options but have little experience there. Thanks in advance for any assistance you suggestions you have.

Categories:

Building flows

Hi @DC-12012025-0

Just a some tiny feedback. When writing please us carriage returns as it's really hard to read.

Next, we don't really write peoples entire flows for them.. meh I guess once in a while some of us do, but its rare, but we can provide a framework of steps then have you build it.

But you have a lot of "requirements" so its better to write this like an actual overview versus a paragraph (details and steps).

This will help us help you, but what we are also looking for, so we can educate and guide, is some searching done. So when you write down the steps, in a step by step format, you will be able to the do searches against that step and create something or at least a pseudo flow.

Lastly, Since you are talking about flows etc, you have to also make sure to be clear on "how" this thing gets triggered / starts. You have 3 options: Manual, Automated (aka triggered) or Scheduled.

Thank that over, re-write it a bit and come back. Just think like hey someone needs my help, how would I want them to write the details of the ask.