Re: Sequential approvals- Using users other than Managers.
Here is a solution that should work for you.
First, I am storing the approvers in a SharePoint list. The list is a custom list with a Title column and a Person or Group column that allows you to select more than one person but not groups.
I am using the Approvers list as a lookup. The type of document is entered in the Title column and the approvers for that type of document are entered in the person or group column. The lookup column is titled "Type of Document".
The Flow starts with a "For a Selected Item" trigger. My document library did not show in the dropdown list, so I entered it as a custom value.
Next, I use a Get File Properties action so that I can retrieve the value stored in the lookup column (Type of Document").
Once I know the type of document, I use a Get Items action to retrieve the row of data that has the approvers. I am filtering the data returned by matching the type of document column with the title column.
Since there can technically be more than 1 row of data returned, I need to use an Appy the Each to work with the row of data returned - there will never be more than 1 row returned so this is OK.
Also, the person or group column has or can have multiple values. Becuase of that, I am using a string variable to store the approver email addresses. I am append an email address followed by a ; to the string with each loop.
I have one more apply to each loop - there will never be more than one row returned but I still need to use an apply to each. This time I start an approval and assign the approval to the string variable that holds my approvers emails.
If this works for you, please mark this issue as solved.
If you have additional questions, please post here.
Scott
