Unanswered

patch Funktion bei nachschlagefeldern in sharepoint

(0) Share

Report

Posted on by MJ-06101352-0

ich habe eine Sharepointliste Buchungen mit ObjektID aus Tabelle Objekte als Nachschlagefeld. Wende ich die Patchfunktion auf ObjektID an (

ObjektID:cmb_Objekt.Selected), so erhalte ich den Fehler: 
Es wird ein Record mit anderem Schema erwartet, es fehlt Spalte vom Typ Number.
In meiner Feldliste zu cmb_Objekt ist ID als Zahl vorhanden, in Sharepoint lässt sich ID nicht bearbeiten (Systemgeneriert)
Wie schreibe ich die Patchfunktion richtig?

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (3)

Answers (0)

mmbr1606 14,453 Super User 2025 Season 2 on at

Like (0)

Report

patch Funktion bei nachschlagefeldern in sharepoint

hello

please share your whole patch code you are currently using,

thanks

Was this reply helpful? Yes No
Kushal_M 64 on at

Like (0)

Report

patch Funktion bei nachschlagefeldern in sharepoint

MJ-06101352-0

As per my understanding, You have a SharePoint list Buchungen with a lookup column: ObjektID → lookup to table Objekte

The lookup column expects a Record with this schema:

{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: Number,
Value: Text
}

But your formula:

ObjektID: cmb_Objekt.Selected

Example Full Patch

Create a record:

Patch(
Buchungen,
Defaults(Buchungen),
{
ObjektID: {
Id: cmb_Objekt.Selected.ID,
Value: cmb_Objekt.Selected.Title
}
}
)

Update a record:

Patch(
Buchungen,
ThisItem,
{
ObjektID: {
Id: cmb_Objekt.Selected.ID,
Value: cmb_Objekt.Selected.Title
}
}
)

if the above patch doesn't work, then please share the patch code which you have written.

🏷️ Please tag me @Kushal_M, if you still have any queries related to the solution or issue persists.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

1 people found this reply helpful.

Was this reply helpful? Yes No
MJ-06101352-0 2 on at

Like (0)

Report

patch Funktion bei nachschlagefeldern in sharepoint

super, vielen Dank, genau das war es und hat mir prima geholfen.

Was this reply helpful? Yes No