Power Platform Community Forum Thread Details

Hello! I am in need of some help. I learned how to create flows but I am no expert by any means. I have a very detailed Flow that is set up like this - When a response is submitted from Microsoft Forms, it pulls user information from O365 and check to see which company and Cost Center the user is with. Then it creates a Sharepoint list item. Depending on which company and cost center the user is with, I need it to send an email to a specific contact. The issue I am having is that I have 5 companies, and each company has multiple different cost centers and each of those have different contacts. Example: Company #1 has 22 Cost Centers, Company #2 has 15 Cost Centers etc. I tried using "Switch" but it doesn't allow me to enter all of the cost centers since there are a total of 53 different ones. I know my Flow is long and detailed, but this is the only way I could get it to work IF I only had 5 cost centers. Again, I am no expert. Can someone assist me in figuring out how I can do this?

Categories:

Building flows

Unfortunately, the screen shots you uploaded are not very helpful since they don't show how any of the actions are configured. Therefore, the best thing that I can suggest is to create a SharePoint list that contains the names of your companies, cost centers, and the approvers.

You can then use a Get items action with a filter query on the company and cost center values to return the approver names.

Another option, which is the method I use, is to use the SharePoint list with this data as a lookup field in the original list. However, this would require either a third-party tool that allows you to modify the list form or the use Power Apps to customize the form. Fortunately, I have access to a third-party tool called Nintex Forms, which makes it much easier than with Power Apps. But if you ever worked with SharePoint 2013 and InfoPath Forms in SharePoint, you'll know what I am referring to.

This is how it works with Nintex for a scenario just like you have. The Legal Entity field corresponds to your company value, and the functional area value corresponds to cost center. The user first chooses the legal entity (company), and that value filters the functional area choices (cost center) to just those for the selected company. Once the functional area is selected, it stores the ID of the selected row from the external list (Delegations of Authority) so I can use a Get item action with the ID stored in the request.