Skip to main content

Notifications

Power Automate - General Discussion
Answered

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

(0) ShareShare
ReportReport
Posted on by

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:
  • Verified answer
    v-yuazh-msft Profile Picture
    v-yuazh-msft on at
    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

  • 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 Profile Picture
    v-yuazh-msft on at
    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:

    Capture.PNG

     

    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:

    Capture.PNG

    Capture.PNG

    Capture.PNG

     

     

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

    Capture.PNG

    Capture.PNG

     

    The leave application list would be updated as below:

     

    Capture.PNG

     

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

     

     

    Best regards,

    Alice

  • faustocapellanj Profile Picture
    faustocapellanj 1,662 on at
    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,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard