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

Notifications

Announcements

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 

 

 

 

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,678 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 759 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 310 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 228

Last 30 days Overall leaderboard