Managing Duplicate Records and Adding New Descriptions in SharePoint List

Like (1) Share

Report

Posted on 17 Jul 2023 09:27:53 by esilvac

Hello everyone! I am developing a Nomination App using Power Apps with SharePoint as the underlying database. In this app, whenever a person is nominated, their ID and description are saved and stored in SharePoint. If another person nominates the same individual again, it is important to avoid creating a duplicate record for that person. Instead, I would like to enable the addition of a new description to the existing record in SharePoint. How can I accomplish this?

All responses (1)

Answers (0)

sandeepstw 302 Super User 2025 Season 1 on 17 Jul 2023 at 09:51:55

Like (1)

Report

Re: Managing Duplicate Records and Adding New Descriptions in SharePoint List

Hi There,

You can do this using
First check duplicate record in SharePoint list.
varExistingRecord = LookUp(SharePointList, ID = txtID.Text)
Then check if it's blank and create new one -
If(IsBlank(varExistingRecord), Collect(SharePointList, {ID: txtID.Text, Description: txtDescription.Text}))
other wise
Patch(SharePointList, varExistingRecord, {Description: varExistingRecord.Description & " " & txtDescription.Text}))

Please give kudos and mark as solution if it helps.

Thanks,
Sandeep Mishra