web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / update SharePoint list...
Power Automate
Answered

update SharePoint list without deleting the old data and having duplicating data

(0) ShareShare
ReportReport
Posted on by 55

Hello,

please I've my excel file generated by my flow that am using to load data in my SharePoint list what I want is to update data without having duplicate data and deleting the old value like (add the data on my share point list without duplicating the value that are already existing and deleting them).

 

any help?

Screenshot 2024-03-11 190522.png
Categories:
I have the same question (0)
  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @flexcodec  do you have any value in excel that can uniquely identify the row?

  • flexcodec Profile Picture
    55 on at

    if you refer to an ID, I don't have but my table in excel files starts with the column name (title), but a name same can have multiple rows. I can say YES, the column name name(title) can be using a unique value. 

  • Verified answer
    annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @flexcodec  okay so the Title column wont have same values in multiple rows?  If yes, in the Apply to each action, you can use Get Items action with Filter Query as below. Then use Condition action to check the length of items returned by Get Items to see if that row already exists in list. In the yes branch of condition action, you can use Update Item action using the ID value from Get Items to update the item in the list, and in the No branch you can keep the Create Item action as you currently have now

    Title eq 'select the title column value from dynamic content here'

     

  • flexcodec Profile Picture
    55 on at

    thanks for your help. this is what am getting for a particular value i don't really know how to deal with. @DJ_Jamba can u assist me please?

     

    flexcodec_0-1711581006949.pngflexcodec_1-1711581025023.pngflexcodec_2-1711581134866.pngflexcodec_3-1711581150137.png

     

  • DJ_Jamba Profile Picture
    2,837 Moderator on at

    Hi @flexcodec 

    You have to escape single quotes. One or more names coming through have a single quote e.g O’Connor

     

    I’m not at my pc so try one of these:

     

    replace(COLUMN,'''','')

     

    or

     

    replace(COLUMN,'''','''''')

     

    so it would be 

    Title eq 'EXPRESSION IN HERE'

  • flexcodec Profile Picture
    55 on at

    Yes am using actually the Incumbent Name column but the problem that i've is the name can be the same in 3 rows but with differents values in others column. Means same name with differents in the percentage  column.

  • DJ_Jamba Profile Picture
    2,837 Moderator on at

    My response was to solve this error. 

    DJ_Jamba_0-1711589127335.png

    is that resolved now?

  • flexcodec Profile Picture
    55 on at

    Am trying your solution

  • flexcodec Profile Picture
    55 on at

    Done it Think it's not longer checking the condition  because it has added duplicated value now.

     

    flexcodec_1-1711590630793.png

     

     

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @flexcodec  is your problem resolved? From screenshot it looks like your filter query has blank value

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 862

#2
Valantis Profile Picture

Valantis 738

#3
Haque Profile Picture

Haque 553

Last 30 days Overall leaderboard