Answered

Is there a better way to create my flow that update sharepoint lists?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, I'm currently making a leave application flow.

scenario:

In the flow, emloyee A ask for manager B's approval, if B approves, then ask B's manager C, then C' manager D. If all approved then the status will be approved.Also, every manager's approval status are needed in the list.

Currently the flow can simply describled like

when an item is created-get createrA-get managerB-update the manger's approve status - if approve continue -if all manager's approve status is approved then the application is approved.

problem:

I understand how to update a sharepoint list but the problem is that there are too many duplicate steps.After finish people with four mangers, I also need to make flow with three managers , two mangers and one manager.

Since flow do not enable me to copy action, do I need to fill in all field whenever I add a sharepoint update item action?Or can I get the status that wheter people have manager, so I donot need to make four flows?

Or is there a better way to make it easier?

Can you offer some help?Thanks.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

faustocapellanj 1,662 on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

To get you started, please check out the video by @JonL.

Microsoft Flow Approval Workflow

Regards,

Was this reply helpful? Yes No
v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous，

Could you please share more details about your leave application list in sharepoint?

You needn't fill in all field when you use update item action,and you needn't create four flows.

I have made a test on my side, and have created a leave application list as below:

All of the response column with type choice and avalible choice is Approve and Reject.

You could refer to screenshot below to create the flow:

When a request is created, and all manager approve the request, the flow would run successfully as below:

The leave application list would be updated as below:

Please take a try on your side on let me know if your problem could be solved.

Best regards,

Alice

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-yuazh-msft
Thanks for answer my first question.
Now I understand that in update item action I only need to change my update content and type choices.
My current flow is similar to yours,but how about my second question?

It is like there are 5 ranks in my company.Rank 1 employee's leave application will need 4 approvals, when rank 5 boss approves the application is finally approved. But for Rank 4 employess there's only 1 approval.
In your example, it is a 3-approval flow, but I don't think it works for people who only need 1 approval.
If the person only has 1 approval, the flow will fail in Get Manager (V2) 2 and the approval result value will stay null.
What I mean is that I need to make 4 flows for rank 1 to rank 4 employees,is that right?
Or is there a way to determine whether the user has a manager so I can make them all in one flow.

Thanks for your help.

Was this reply helpful? Yes No
Verified answer

v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

There is no anyway to check if a user have a manager so you might need to create 4 flows for your scenes.

And if a user don't have manager, use the "Get manager" action would run failed with error :

Resource 'manager' does not exist or one of its queried reference-property objects are not present.

Best regards,

Alice

Was this reply helpful? Yes No