Need help in stop adding duplicates in a SharePoint List

(1) Share

Report

Posted on by ram_ESP

Hi Team, I have totally 5 columns in a SharePoint List. Few people copy and paste via excel or do a manual entry.

I wanted to trigger an email if column PO NUMBER and LINE NUMBER is already available in the list.

Example: if the list has PO NUMBER column is 123456 and line number is 5 and if a user tried to add the same two entries then I wanted to trigger an alert to an email ID. Is this possible?

Thanks,

Ram

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @ram_ESP

Follow the below steps:

Expression I used under the IF condition is as follows:

length(body('Get_items')?['value'])

Under the filter query you can see I used PO_x0020_NUMBER, that's because the column name have spaces between. If you don't have spaces then use PONUMBER. Also here I created both columns as numeric. If they are string the use single quotes around it under the filter query.

eg:

Thanks

Was this reply helpful? Yes No
ram_ESP 78 on at

Like (0)

Report

Hi Team, This is showing an error.

Was this reply helpful? Yes No
ram_ESP 78 on at

Like (1)

Report

This is the error

Was this reply helpful? Yes No
ram_ESP 78 on at

Like (0)

Report

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

Like (0)

Report

Hi @ram_ESP

I already mentioned in my earlier post. You can't put spaces for the columns under the filter query.

See below

Under the filter query you can see I used PO_x0020_NUMBER, that's because the column name have spaces between. If you don't have spaces then use PONUMBER. Also here I created both columns as numeric. If they are string the use single quotes around it under the filter query.

Thanks

Was this reply helpful? Yes No
ram_ESP 78 on at

Like (1)

Report

HI, I see the same error with or without codes for the same filter query you used. I have used even and in Uppercase and Lowecase in the filter query and still the same error.

PO Number - Column Type is Single line of Text
Line Number - Column Type is Single line of Text

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

Like (0)

Report

Hi @ram_ESP

Again if you look carefully the filter query you used capital case AND. This should be small case and. See my earlier thread.

Thanks

Was this reply helpful? Yes No
ram_ESP 78 on at

Like (0)

Report

Found the issue with column expression. They have used Title as PO Number column name. I changed the expression.

Was this reply helpful? Yes No
ram_ESP 78 on at

Like (0)

Report

I see another problem now. the PO Number and Line Number values added to the list and I am not getting an email.

I have tried to add the existing column value and it is not triggering an email.

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

Like (0)

Report

Hi @ram_ESP

Could you please post a screenshot of your flow?

Thanks

Was this reply helpful? Yes No