New Employee workflow

[mlott1785]

Hello,

New to power workflow. I am trying to make it easy to set up a new user starting at  HR send an email to the manager to add a user profile, and after the manager adds their info send an email to IT to create an account for the new user. Once IT has finished creating the account an email is sent back to HR  and the manager that the new employee's account is ready.

I have the flow but having issues with too many repeated emails. Here is my flow

This part is when HR adds the first and last name and yes to complete an email is sent over to the manager.

My problem is after the yes that triggers an email to the manager that goes through without a problem. The second condition is when the manager completes their part an email is sent to the IT department, but an email is sent to the HR and the Manger, and then the email is resent to the IT department. which this should not be. How can I just have an email sent to Manager and then the IT department and not resend the past emails again?

[#2]

@mlott1785 you're getting multiple email because the flow triggers every time the SharePoint item is modified, which column that might be. Make sure you turn on versioning in your list settings. Then your trigger should be when an item or a file is modified. Then you have the get changes action but instead of Trigger Window in the Since and Until fields use an expression of 

sub(int(triggerOutputs()?['body/{VersionNumber}']),1)

in the Since field only. That will check the current version of the item against the previous version. Then have a condition of Has column changed: xyz. If it has then do an action. If it hasn't then do nothing or do another action.

That way you can prevent your flow triggering every time the list item is modified and only have it trigger when the column you want is modified.

Rob
Los Gallardos
Microsoft Power Automate Community Super User

[#3]

I appreciate the info, Being new how do I add the sub(int(triggerOutputs()?['body/{VersionNumber}']),1) line?

@RobElliott 

[#4]

@mlott1785 click in the field and the dynamic content box will open click the Expression tab and paste it into the box.

Rob
Los Gallardos
Microsoft Power Automate Community Super User

[#5]

Okay I added the expression and when I run it the first time In the test I get this error
"Specified Version Label does not correspond to any actual version
clientRequestId: 6485004e-6169-48f6-93cb-9bb5540650aa
serviceRequestId: 6485004e-6169-48f6-93cb-9bb5540650aa"
But when I make a change and run it again no error version is changed to 2. Another thing I notice it still sends out all three emails. instead of the conditions, I told it to trigger.

[#6]

Did you turn on versioning on the list?

[#7]

Yes I have.

[#8]

I can't second-guess what's happening, you need to add screenshots of your current flow.

[#9]

@RobElliott 

When I run the flow in the test I get the flow failed

But when I run it a second time it is okay.

[#10]

@RobElliott 

 I meant to say the error does not show when I run it again. When my second condition is completed I still receive the first Email and the second.

Here is my second condition.

The manager finished and the condition was only yes. Send an email to the administrator.