Updating existing items in a list

(0) Share

Report

Posted on by 8T_Bird6

I feel this is very elementary, but im to new at this.

My flow automatically exports items from an excel table into a SP List when an "Item is created or modified".

The problem is that after the list populates for the first time, the next time the flow runs it says "Failed". This is because it says a duplicate value was found and it could not update list item.

Currently, the list itself has "Enforce Unique Values" turned ON for a column (which is needed because i cannot have duplicates). This unique value column data will not change, but the columns following it will throughout the day (This is a part tracking list showing which department a certain part is in)

So, even though the flow says "Failed" due to duplicate values in previous mentioned column, will it still update other columns if data changes? If not, how can i modify my flow to update list items without adding duplicates?

Screenshot of the list:

The first column "Title" has "Enforce Unique Values" set to YES within the list settings page. The second column and last column are the ones who's info will need to be updated throughout the day

Categories:

General topics

All responses (4)

Answers (0)

Sort by

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@8T_Bird6

My suggestions is as follows:

First, use a list rows in a table action

Include a filter query so that only rows with the unique column value are returned

If any rows are returned (there should either be one or none, the use an Update item action

If no rows are returned use a create item action

You can check to see if any rows were returned by using a length() expression
8T_Bird6 9 on at

Like
a
(0)

Report
Copy link

Link copied!
@ScottShearer wrote:
@8T_Bird6
My suggestions is as follows:
First, use a list rows in a table action
Include a filter query so that only rows with the unique column value are returned

The excel table is not the one that will have duplicates, it is the List being populated by the excel table.

Before i enforced unique values within list, everytime the flow ran it would upload duplicate rows of data. After enforcing unique values within list, the flow fails if the unique column value exists, eventhough the last column value data changed<<<<which is what i need. I need rows of data to update throughout the day without creating duplicates based on first column unique value.
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@8T_Bird6

OK - then use a Get Items action in place of the Get rows action with the same logic and a similar filter query. The idea is that you want to know if a rows exists in SharePoint with that value.

I will provide an example shortly.
8T_Bird6 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much, looking forward to it!