Select person for approval from Forms

[Igor_Sergeev]

Hello everyone! Happy New Year and Merry Christmas!

The fact is that you need to prepare a platform for registering applications using Forms. I have already prepared the form. But I am having problems configuring Power Automate. I did not find the answer either in the documentation or on the forum. And now I have been suffering with this problem for a couple of months. I will be very grateful for your any help!

The task is for a person to be able to choose a professor for confirmation in the form (if he is not included in the list of those who have the right to send an application without confirmation), and then he could choose the type of application, fill out its application and send it.

How did I implement this? 

 First, I created a table in the cloud. Thanks to the table, we can check if a person has the right to send an application.

After that, I created a flow that will be triggered when a new response is received.

1. We indicate the trigger.
2. I indicate my form.
3. Receive information about the person who filled out the form: his full name, his email and other data.
4. Indicate the path to the table where the professors and their mailboxes are indicated.
5. Initialize a variable that takes a negative value.
6. Check if the person's email is included in the list of those who have the right to send an application without confirmation. If the email is in the list, then the variable is true. (Will the variable change its value throughout the flow, or only in this section?)

6 point

7. If the variable has a true value, then, based on the selected type of request, a message is sent to this or that person. If the  value is negative, then the person receives a message that he is not included in the list of those who can send an application.

7.1. I use a switch that determines what type of application was specified and, accordingly, what information should be indicated in the sent letter to the specified person.

8. We register the application in the table for collecting statistics.

As a result, this algorithm can only check whether a person has the right to send an application, and then notify this or that person.

But the problem is more extensive: if a person does not have the right to register an application, but he indicated a person for approval, then the application must go through approval and register only with a positive decision.

That is, the flow must find the selected person from the form in the table (Excel table in the cloud) and read the adjacent cell with his email.

If you have any ideas how it can be implemented differently - share, please.

Thanks in advance for any of your help!

Sincerely,
Igor

[PrasadAthalye · Accepted solution]

Instead of List Rows in excel can you try to use a Get a Row action? If a person does not have the right to register the application, in no section, you can write another Get a Row action to query again?

[Igor_Sergeev]

Hello!

If you show the flow as an example, then I will be very grateful to you!

[PrasadAthalye]

Below is an example... I have multiple columns in my excel. I am getting a row by filtering on Sr No column where value equals 3 and then use other column values on the same row as needed...