Answered

find duplicate and update status value to Duplicate item

(1) Share

Report

Posted on by Dhaval2002p

103

I appreciate it if you can help me to build a workflow for this SharePoint list. I tried multiple methods but for some reason, it's updating the status for all new items even though it's not duplicate.

When the item is created
Search Testid duplicate
if a duplicate testid is found then update the most current date time item Status value to "Duplicate item"
Send an email to Manager- duplicate item found in the list take appropriate action.

Categories:

General topics

I have the same question (0)

All responses (31)

Answers (1)

abm abm 32,981 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Dhaval2002p

Try the following:

Final Flow

Above change the filter query. In your case use TestId eq 'map the trigger value when Item created'.

If you status column is plain text then under the Update Item set that value. If its a single choice field please have a look at my tutorial video about to update the choice column in SharePoint.

https://www.youtube.com/watch?v=eKsVF0om0mk

Thanks

Thanks

Was this reply helpful? Yes No
Dhaval2002p 103 on at

Like (0)

Report
Copy link

Link copied!

workflow error at "GetIitems'
I tried Testid eq'Testid' and also testid eq'created'
both fail

Was this reply helpful? Yes No
abm abm 32,981 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Dhaval2002p

I can see you are trying to filter against created, which is a date field. You need to map the TestId from the trigger (very first step). See where I am mapping in my earlier post Title eq 'Name' where name is mapped from the very first step.

Thanks

Was this reply helpful? Yes No
Dhaval2002p 103 on at

Like (1)

Report
Copy link

Link copied!

You mean Testid eq 'Testid'?

Was this reply helpful? Yes No
abm abm 32,981 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Dhaval2002p

"Search Testid duplicate" this is what you mentioned so it should be.

Was this reply helpful? Yes No
Dhaval2002p 103 on at

Like (1)

Report
Copy link

Link copied!

workflow run successfully but the status didn't update for the duplicate item. I have a very basic knowledge of programming. Sorry for taking your time.

Was this reply helpful? Yes No
abm abm 32,981 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Dhaval2002p

Have a look at carefully what I suggested earlier

That IF condition should be outside the loop. Also if your TestId is a numeric column you don't need single quotes under the Filter query.

TestID eq TestID (Here without the quotes)

Thanks

Was this reply helpful? Yes No
Dhaval2002p 103 on at

Like (0)

Report
Copy link

Link copied!

error, I attached the full workflow with a loop

Was this reply helpful? Yes No
abm abm 32,981 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What is the error. I can see the flow? Can't see what error you getting.

Was this reply helpful? Yes No
Dhaval2002p 103 on at

Like (1)

Report
Copy link

Link copied!

Was this reply helpful? Yes No