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

Like (0) Share

Report

Posted on 12 Jun 2018 00:56:56 by Community Power Pla...

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 Questions

All responses (4)

Answers (1)

Verified answer

v-yuazh-msft on 13 Jun 2018 at 09:29:19

Like (0)

Report

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

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
Community Power Pla... on 13 Jun 2018 at 05:07:11

Like (0)

Report

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

@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.
v-yuazh-msft on 13 Jun 2018 at 03:20:03

Like (0)

Report

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

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
faustocapellanj 1,662 on 12 Jun 2018 at 06:20:22

Like (1)

Report

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

Hi @Anonymous

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

Microsoft Flow Approval Workflow

Regards,