Update a SharepointList Item or create new

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello guys,

I try to store Items in sharepoint list, or update them. (See picture)

Now I have the problem, with the following code

Patch(
 Abteilungen,
 First(Filter(Abteilungen,Title)),
 {
 'Anzahl Mitarbeiter':Value(Abt_Mit.Text)
 }
);

I only update I should update the amount of Employees. (Which isn't working but that's not the point)

But I cant create new items in that list with that code, therefor that code would work

Patch(
 Abteilungen,
 Defaults(Abteilungen),
 {
 Title: Abteilung.Text,
 'Anzahl Mitarbeiter':Value(Abt_Mit.Text)
 }
);

But this doesn't allow updating one of them, just make duplicates.

I thought about some solutions but can't get them into power apps code.

In words would be like:

If (Abteilungen.Text equals one title in the sharepoint list )
 -> {update this entry}
else 
 -> {create new}

But how can i get this working.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (3)

Sort by

WarrenBelz 155,972 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Assuming Title is the unique identifier here

With( { wID: LookUp( Abteilungen, Title = Abteilung.Text ).ID }, Patch( Abteilungen, If( IsBlank(wID), Defaults(Abteilungen), {ID:wID} ), { Title: Abteilung.Text, 'Anzahl Mitarbeiter':Value(Abt_Mit.Text) } ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Nearly perfect but in the
{ID:wID}
Power Apps tell me the following error
Invalid argument type(Record). Expecting a Boolean value instead.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,972 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

ID is numeric - not sure on the Boolean reference, but you could try

With( { wRecord: LookUp( Abteilungen, Title = Abteilung.Text ) }, Patch( Abteilungen, If( IsBlank(wRecord.ID), Defaults(Abteilungen), {ID:wRecord.ID}, ), { Title: Abteilung.Text, 'Anzahl Mitarbeiter':Value(Abt_Mit.Text) } ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

No, there also pops up the "name isn't valid error"

Was this reply helpful? Yes No
WarrenBelz 155,972 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,

That relates to the values you posted - what name does the error relate to?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Maybe I should tell you more:

Textfeld 1: Abteilungen
Textfeld 2: Abt_Mit

The Sharepoint List looks like this:

Was this reply helpful? Yes No
WarrenBelz 155,972 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,

You have wID at the top and wRecord.ID at the bottom.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

You're right. I'm sorry. My bad.
Ichanged that but this ends in the same error with expecting boolean

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,972 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous ,

Your brackets are in the wrong place in the Patch.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz

After some updates it didn't work for me, but I found a solution:

With( { wRecord: LookUp( Abteilungen, Title = Abteilung.Text ) }, If( IsBlank(wRecord), Patch( Abteilungen, Defaults(Abteilungen), { Title: Abteilung.Text, 'Anzahl Mitarbeiter': Value(Abt_Mit.Text) } ), Patch( Abteilungen, First( Filter( Abteilungen, Title = Abteilung.Text ) ), { Title: Abteilung.Text, 'Anzahl Mitarbeiter': Value(Abt_Mit.Text) } ) ) )

Was this reply helpful? Yes No