Power Platform Community Forum Thread Details

Hi,

I am newbie in this application. We have requirement about workflow approval for work order & helpdesk ticketing.

Currently, we explore power apps, sharepoint, and flow but stuck in the approval path.

Our scenario is, we have 2 approver. How can we assign the approver based on who apply the request or which type of work.

example:

Approver

Approver A only approve request from requestor A

Approver B only approve request from requestor B

Approver A: Approver B:

Type of work Type of work

- Change request - New request

- Bug Fixing - enhancement

Thank you

Noble

Categories:

Using flows

Hi @victoria_noble,

Could you please share more details about the data structure in your SharePoint?

I suppose that you store the data of work orders in your SharePoint list. I have created a SharePoint list to store the data of Work Orders, the data structure as below:

Requestor Single line of text (requestor A, requestor B)

TypeofWork Choice (New request, Change request, Bug Fixing and Enhancement)

RequestContent Single line of text

I have made a test on my side and please take a try with the following workaround:

Add “When an item is created” trigger.
Add a Condition, click “Edit in advance mode”, type the following formula:

@and(equals(triggerBody()?['Requestor'], 'requestor A'),or(equals(triggerBody()?['TypeOfWork']?['Value'], 'Change request'),equals(triggerBody()?['TypeOfWork']?['Value'], 'Bug Fixing')))

Within “If/yes” branch of Condition, add “Start an approval”. Assigned to filed set to Approver A.
Within “If/no” branch of Condition, add a Condition 2, click “Edit in advanced mode”, type the following formula:

@and(equals(triggerBody()?['Requestor'], 'requestor B'),or(equals(triggerBody()?['TypeOfWork']?['Value'], 'New request'),equals(triggerBody()?['TypeOfWork']?['Value'], 'Enhancement')))