Answered

add row to excel not duplicate

(1) Share

Report

Posted on by amyharkus86

726

I am using flow to add row in an excel table from a sharepoint list I'd like it to check that the item is not already in excel before adding it.

i'd like to do this by checking that the ID number in the excel spread sheet is not the same as the ID number from sharepoint, if it is not then it will add the row

This is what i have at the moment and i am getting duplicates.

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@amyharkus86 you flow looks correct, can you share the outputs of filter List rows and filter array action from the flow run to further understand on whats going on in the flow when it runs.

Was this reply helpful? Yes No
amyharkus86 726 on at

Like (0)

Report
Copy link

Link copied!

@annajhaveri please see screen shots of the flow once its ran, all looks to be doing as it should, but as you can see from the screen shot of the table within excel test runs it has the same ID number 1449 in this case and there are 3 entries, it should only add it if that number is not already in the spreadsheet.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@amyharkus86 from screenshots it looks like the filter array is not working, it doesnt return any matching results, are you sure the SharePoint ID is there in the excel? Need to check in outputs of List rows present in table.

Was this reply helpful? Yes No
amyharkus86 726 on at

Like (0)

Report
Copy link

Link copied!

@annajhaveri Yes the ID is present in both, here is a snippet from my excel file, as you can see in the second column i have 'ID' this is the ID count from the sharepoint list.

I have a PowerApps that creates an item in a SharePoint list on submission, then the flow on a new item being created in the SharePoint list adds the row to excel.

Was this reply helpful? Yes No
Verified answer

amyharkus86 726 on at

Like (0)

Report
Copy link

Link copied!

After further research i found that others have had the same issue, the solution that also worked for me was to re-create my excel spreadsheet, so i copied all the data and formatting across, and re-pointed my flow to my new excel spreadsheet, I am no longer getting duplicates.

Was this reply helpful? Yes No
oaltheeb 2 on at

Like (0)

Report
Copy link

Link copied!

Could you share how did you point your flow to the new Excel sheet?

Was this reply helpful? Yes No
amyharkus86 726 on at

Like (0)

Report
Copy link

Link copied!

@oaltheeb i used the flow function 'When an item is created or edited'

For me Record ID is the name of the field in my excel file that hold the ID

for the string enter under expression, you may not be able to copy and paste and will need to type it yourself.
string(triggerOutputs()?['body/ID'])

I then have a condition that is using the outcome of the string in the filter array, Is its empty equals true
Being if the ID field is empty = true, enter row in to the table.

Was this reply helpful? Yes No
Andrew92 2 on at

Like (0)

Report
Copy link

Link copied!

Would to be able to provide the Empty string you have in your condition section?

Was this reply helpful? Yes No
amyharkus86 726 on at

Like (0)

Report
Copy link

Link copied!

@Andrew92
empty(body('Filter_array'))

Was this reply helpful? Yes No