Unanswered

How do i update a record that already exist in a SharePoint list, without creating a duplicate record?

(1) Share

Report

Posted on by Spawn10

330

I have an app that is using a SharePoint list as a data source. I have a save button on a screen, and when I click save...I want to update an account if it already exists in the SharePoint list. Currently, my code is creating a duplicate entry. Here is what my logic looks like right now...

If(
	IsBlank(
 LookUp(
 MySPList,
 MyID = IDInput_1.Text
 )
 ),
			Collect(
				MySPList,
				{
					MyID: IDInput_1.Text,
					Title: AccountNameInput_1.Text,
					ClientName: ClientSelect_1.Selected.Name,
					ClientEmail: ClientEmailInput_1.Text,
					FirmID: FirmIDInput_1.Text,
					Strategy: StrategyInput_1.Selected.Value,
					SelectAttach: Attachments,
					Status: StatusDrpDwn.SelectedText,
					EmailContent: EmailBody_1.Text
				}
			),
			Patch(
				MySPList,
				LookUp(
					MySPList,
					MyID = IDInput_1.Text
				),
				{
					Title: AccountNameInput_1.Text,
					ClientName: ClientSelect_1.Selected.Name,
					ClientEmail: ClientEmailInput_1.Text,
					FirmID: FirmIDInput_1.Text,
					Strategy: StrategyInput_1.Selected.Value,
					SelectAttach: Attachments,
					Status: StatusDrpDwn.SelectedText,
					EmailContent: EmailBody_1.Text

				}
			)
);

How can I get this to just,

1 - update the record that already exist, or

2 - create an entry if it does not exist already?

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

Isa_Watanabe 38 on at

Like
a
(1)

Report
Copy link

Link copied!
I am not sure why the creation of the collection was necessary, but here is how I'd do it.
Basically it's: IF(Item Does Not Exists, Create Item in SharePoint, Otherwise Update Item in SharePoint)

If( IsBlank(LookUp(MySPList,MyID = IDInput_1.Text)), Patch( MySPList, Defaults(MySPList), { Title: AccountNameInput_1.Text, ClientName: ClientSelect_1.Selected.Name, ClientEmail: ClientEmailInput_1.Text, FirmID: FirmIDInput_1.Text, Strategy: StrategyInput_1.Selected.Value, SelectAttach: Attachments, Status: StatusDrpDwn.SelectedText, EmailContent: EmailBody_1.Text } ), Patch( MySPList, LookUp( MySPList, MyID = IDInput_1.Text ), { Title: AccountNameInput_1.Text, ClientName: ClientSelect_1.Selected.Name, ClientEmail: ClientEmailInput_1.Text, FirmID: FirmIDInput_1.Text, Strategy: StrategyInput_1.Selected.Value, SelectAttach: Attachments, Status: StatusDrpDwn.SelectedText, EmailContent: EmailBody_1.Text } ) );.
rebeccas 2,591 on at

Like
a
(0)

Report
Copy link

Link copied!

If you can just do a form that is much better.

You can make it go between New/Edit Form mode easily. Patch is slower and not near as reliable as using the Forms that were designed for PowerApps.