Answered

Add new or edit existing SP list item

(0) Share

Report

Posted on by romankorchak1

Hi All

What is the easiest way to update Sharepoint list item (if it exists) or add (if dont exist).
So I have a list with columns TempId and Data, and I have some data {TempId:23, Data:"Some Data"}, and I want to check if the item with TempId exist, and, if exists, update its Data, or, if not exists, create new item with TempId 23 and Data "Some Data".

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

PowerApps Duplicates - Avoid, highlight, and even delete - YouTube

This will help

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @romankorchak1 ,

Something like below code will work in your case. Please update according to your data source and controls.

If( IsBlank(Lookup(DataSource,TempId =23).ID), Patch(DataSource, Defaults(DataSource),{ TempId:23, Data:"Some Data" } ), UpdateIf(DataSource,Lookup(DataSource,TempId =23).ID,{ TempId:23, Data:"Some Data" }) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @romankorchak1,

Have you solved your problem?

Do you want to check if a special id existing in the SP list and update it?

Could you please tell me if these columns are Text type?

1). Add a TextInput to input your special dynamically TempId, set its OnChange property as below:

If(IsBlank(LookUp(Product,TempId=TextInput14.Text)),NewForm(Form3),EditForm(Form3))

2). Add a Form and set the Item based on the TempId, if it exists, make it an edit form, if it not exits, make it a new form.

Set Form Item as below:

LookUp(Product,TempId=TextInput14.Text)

3). Add a submit button and set OnSelect as below:

SubmitForm(Form3)

Note that this solution helps you fill in dynamic TempId and update data dynamically.

Was this reply helpful? Yes No