Forum Discussion
New Employee workflow
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...
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
I appreciate the info, Being new how do I add the sub(int(triggerOutputs()?['body/{VersionNumber}']),1) line?
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- 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.- Did you turn on versioning on the list?