Hi, I am by no means a Flow expert so please be gentle.
I am trying to make a flow that sends an email if a new item is created on a SharePoint list, but with a condition that IF that item contains a duplicate, send an email to someone else and then continue running the flow.
I have seen multiple posts partially explaining how to possibly do this, but they don't all explain the full process.
Can anyone help?
I have detailed how to check if an item exists on a sharepoint list in the article below:
So you can follow the steps to check if an item exists but modify the actions you take.
Hope this gives you an idea!
It is not lack of knowledge but you just can't get your head around it, can you share how you structured your flow.
Also I see it as the below steps:
1.Trigger of your flow should be when an item is created
2. Then you need to check for duplicate and this is should be through List items action with a filter that determines if an item with this filter already exists like for example ID eq '3'
If this List Items returned records this means that the item is duplicate.
If you share more details about your list structure and how you can detect duplicate.. I can provide you with a complete example.
I hope you are right.
I have a column in a list called 'Pupil' which is comprised of email addresses and I want the flow to detect that and email accordingly.
Does my screenshot make sense or have I gone on a wild goose chase?
Is the trigger and Getitems on the same List, can you share a screenshot of the list itself?
I just wanna understand pupil and pupil email address but overall the flow looks good and you are almost there!
What is the type of the pupil column? Is it user group?
Thanks for your help.
Yes, the trigger and list are the same.
Pupil column is email address which is auto filled when you search for a user but it's not a group email.
Hi, this causes the flow to fail.
I think the flow does actually run now, however I can't work out how to make the flow action the Condition.
Please see screenshot.
As per your screenshot the flow didn't fail but the condition didn't evaluate to true that's why the email was not sent.
Also from the flow run you are still using Pupil and not Pupil/EMail and also the value passed is empty.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.