cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Earl20
Helper III
Helper III

Help with my flow to check SharePointlist if Department or Manager changed

I have a Sharepoint list when a new item is created MS flow pulls the person Department name and Manager name from user profile and stores in 2 field for each

1) Manager Name

2) (hidden) Recorded Manager name 

3) Department name

4)(hidden) Recorded Department name

 

I'm trying to build a scheduled flow that will every 2 weeks pull the existing department name and manager name (without changing whats currently listed in the sharepoint column) then compare it to what was recorded in the Recorded manager and department field. If its different to send an email to me letting me know that both have changed

 

My current flow:

 

Every 2 weeks 

Get Items Action: SharePoint site address and list

Apply to each action : Value from get actions item

Get User profile action

Get manager  action

Condition Action:   (grouped) Department (take from get user profile action) is not equal to Recorded Department field from Sharepoint  

AND Manager (taken from get manager action) is not equal to Recorded Manager name field from sharepoint

 

IF YES:

Send an email to me saying manager and dept changed

IF NO: Workflow ends

 

 

When I run the workflow it fails and says  "ACTION FAILED no dependent action suceeded" 

 

Not sure what im doing wrong. Any help would be appreciated

 

1 REPLY 1
eric-cheng
Solution Sage
Solution Sage

Hi @Earl20 ,

 

The error you are getting indicates an error somewhere in your flow and it has stopped running.

 

Can you post a screenshot of your flow and the run history and where it has failed.

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (3,266)