It should be simple but.... Patch-Funktion

(0) Share

Report

Posted on by cAhler

I created two SharePoint lists to connect them using a button in Power App.

The aim should be to connect the lists with each other using a button.

What happened until now:

Gallery1 = SharepointList "Group" with just thre sample Items: Red, Green, Blue as Title, the SharepointID as ID Coplumn and a Column "Partner" as Lookup for the List EDV/ID

Gallery2 = SharepointList "EDV" Just three smple Items like Laptop, Monitor and keyboard as Title and the Sharepoint List ID.

When I edit an item in the "Group" list, I can select an item from the "EDV" list in "Partner" column. So far that looks right to me.

Now I have created a new, empty PowerApp “Test” and only included the catalogs of the lists here. On the left the catalog for the Group (Gallery1) and on the right the catalog for EDV (Gallery2). I used the Sharepoint connector for both.

Then I added a button to write the ID from the EDV list into the "Partner" column of the "Group" list. The selected ITEMs of the galleries should be taken into account.

I used this code:

Patch(
 Gruppen,
 {ID: Gallery1.Selected.ID},
 {Partner: Gallery2.Selected.ID}
);

Notify("Success!", NotificationType.Success);

But this button doesn't work and is directly marked with a red cross.

Error Message:

Bildschirmfoto 2023-12-11 um 16.46.23.png

I have absolutely no idea why!

Could it be due to the connection to the "Group" list in the patch function? The lists are assigned to mycompany.sharepoint.com

Anyone have an idea?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sickle-Cell 600 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @cAhler,

Your formatting is wrong, try this:

Patch( Gruppen, Defaults(Gruppen), {ID: Gallery1.Selected.ID, Partner: Gallery2.Selected.ID} ); Notify("Success!", NotificationType.Success);

Was this reply helpful? Yes No
cAhler 12 on at

Like (0)

Report
Copy link

Link copied!

Thanks, but i still have errors on the Function OnSelect.

Look at the Screenshots please:

Error 1:
Error 2:

Error 3:

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @cAhler,

The LookUp column expects a format like below:

{ Id:ID//ID from EDV list Value:Value }

So, please modify as below:

Patch( Gruppen, {ID: Gallery1.Selected.ID}, {Partner: {Id:Gallery2.Selected.ID Value:Gallery2.Selected.ID} } ); Notify("Success!", NotificationType.Success);

Was this reply helpful? Yes No
cAhler 12 on at

Like (0)

Report
Copy link

Link copied!
Here is my solutions for this, for people with the same Problem. 😉

Patch(Kredite;{ID:gal_Kunden.Selected.ID;Partner:{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";Id: gal_FeWo.Selected.ID;Value: gal_FeWo.Selected.Name}});;

Was this reply helpful? Yes No