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 Apps / remove duplicated reco...
Power Apps
Unanswered

remove duplicated records in dataverse colmun tables in LookUp

(0) ShareShare
ReportReport
Posted on by 88

Hi everyone 🙂 

i have Problem with duplicated records in tables at the dataverse: in my Portal app when user logged in and fill in the tables field, it save in the dataverse as new record but when the same user fill in again the table then the records updated in new row in the table and that make duplicate result in my Lookup in canva.. how can i let the all rows for the same users at one row and update the redords at same row... please Help 🙂  here the Screenshots 

 

 

 

1.png
2.png
I have the same question (0)
  • AbdulWahab Profile Picture
    517 on at

    Hi jwan_gain

     

    As per my understanding, the issue is on the portal side. I think you need to clarify highlighted part more "in my Portal app when user logged in and fill in the tables field, it save in the dataverse as new record but when the same user fill in again the table then the records updated in new row in the table"

     

    Let me know if I can provide you with more details.

     

    Thanks

    Regards,

     

    Abdul Wahab
    Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/

  • jwan_gain Profile Picture
    88 on at

    i created one Table in dataverse to use it in my portal app, but every time my users log in and submit the table i get new row in the dataverse for this table, is there way to merge all rows they belong to same user under just one row and the updates go there ?
    1.png2.png

  • AbdulWahab Profile Picture
    517 on at

    Hi jwan_gain,

     

    Instead of merging records. Do you not think you need to stop record creation from the portal on the submit button? Sorry if it does not make sense.

     

    Let me know if I can provide you with more details.

     

    Thanks

    Regards,

     

    Abdul Wahab

  • jwan_gain Profile Picture
    88 on at

    You are right ! But that submit button belongs to table its come from dataverse, ...to stop it? Will be good if the new records come at same row  when user submit again the table -----as update maybe? 

  • jwan_gain Profile Picture
    88 on at

    Sorry maybe i was not clear enough:  @AbdulWahab 
    i have a 5 basic forms created (not advanced Form): and i inser the whole Forms to my portal App, In the dataversem, when i go to tables -- > to my Table (one Table has 5 basic Forms) i see the update records from the User, when he submit the form as new row at my table, and i want to have just one row, every row belongs to one User, and when the User submit again or on another Form at same table should the Records update it at the same row.. 
    w shokran salafan 🙂 
    Jwan Ibrahim

  • AbdulWahab Profile Picture
    517 on at

    Hi jwan_gain,

     

    Are you using Entity List or just Entity Form?

     

    Let me know if I can provide you with more details.

     

    Thanks

    Regards,

     

    Abdul Wahab
    Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/

  • jwan_gain Profile Picture
    88 on at

    hi Abdul Wahab 🙂 i use just Entity Form (i created 5 forms) all of them under one Table ..

  • AbdulWahab Profile Picture
    517 on at

    Hi jwan_gain,

     

    That is the reason your portal user is creating records every time.

    You should need to use Web Page + Entity List. 

    Your portal user should see something like the below:

    AbdulWahab_0-1660642503859.jpeg

     

    Let me know if I can provide you with more details.

     

    Thanks

    Regards,

     

    Abdul Wahab
    Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/

  • jwan_gain Profile Picture
    88 on at

    Thank you so much for helping 🙂 but i didnt understand why my users should see the List ?! 
    can you explain more please,, am not so much Professional on that 😞 thanks again 

  • AhmedSalih Profile Picture
    6,680 Moderator on at

    Hello, @jwan_gain , What is the mode of your Form? 

    You might need two forms, one to Insert and one to Edit. Add them to two different sections pages accordingly.

     

    Mode: Select one of the following options:

    • Insert: Indicates the form should insert a new record upon submission.

    • Edit: Indicates the form should edit an existing record.

    • Read only: Indicates the form should display an existing record's non-editable form.

    Check this documentation for more info. https://docs.microsoft.com/en-us/power-apps/maker/portals/add-form

     

    Regards,

    Ahmed

    If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

    My Blog: www.powerplatformplace.com

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!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard