Answered

Patch a new reconrd to a SharePoint List with a Field from A Text Input and a Lookup Field

(0) Share

Report

Posted on by RPowerAutomated

Hello everybody.

Patch(
 testProjekt_Lokal; 
 Defaults(testProjekt_Lokal);
 { 
 Projekt_Name: TextInput1.Text;
 KundeID: 
 LookUp(
 testKunde_Lokal; Kunde_ID = ComboBox2.Selected.Kunde_ID)
 }
)

Trying to patch with a button the text content from a Input Field (TextInput1.Text) and the selected value in a combo box (ComboBox2.Selected.Kunde_ID). Those values are called in the SharePoint List respectively "Projekt_Name:" and "KundeID". KundeID is a LookUp Field.

Now I have no clue why this is not working. Three error messages so far:

That means:

1) Invalid argument type. Expecting a record value, but of a different schema.

??? testProjekt_Lokal has only optional values and I am patching those values:

It makes no sense at all.

2) Error message regarding missing column

3) Invalid arguments for PATCH.

I have no clue, can somebody help?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

jorge.daniel 1,430 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

This LookUp( testKunde_Lokal; Kunde_ID = ComboBox2.Selected.Kunde_ID) looks good but power apps doesn´t like it.

Usually, putting things in a label helps in getting additional hints on what may be wrong.

Was this reply helpful? Yes No
dukatz 165 on at

Like (1)

Report
Copy link

Link copied!

To Patch al LookUp field you need to pacth the ID and the value of the LookUp. You're only patching the ID once. here is an example PATCH A SharePoint LookUp Column In Power Apps - Matthew Devaney

Was this reply helpful? Yes No
RPowerAutomated 42 on at

Like (0)

Report
Copy link

Link copied!

The Example has to have two values, one for ID and nome for the Value. But I Only need the ID from "Kunden" in my Projekt list.

The example dosent help at all, since the id is hardcoded there (2) but I want to retrieve it from a combobox selection.

Was this reply helpful? Yes No
RPowerAutomated 42 on at

Like (0)

Report
Copy link

Link copied!

If I add a last Argument to my lookup it will work and give the selected ID back:

Still the Patch Function wont work.

Was this reply helpful? Yes No
Verified answer

RPowerAutomated 42 on at

Like (1)

Report
Copy link

Link copied!
This worked for me:

Patch( testProjekt_Lokal; Defaults(testProjekt_Lokal); { Projekt_Name: TextInput1.Text; KundeID: { Id: ComboBox2.Selected.Kunde_ID; Value: LookUp(testKunde_Lokal; Kunde_ID = ComboBox2.Selected.Kunde_ID; Kunde_ID) } } )

Basically split the Lookup Field in the Child Table in Id and Value. They are both necessary.
Thanks @dukatz for the Link.

Was this reply helpful? Yes No
dukatz 165 on at

Like (0)

Report
Copy link

Link copied!

ID is internal for Power Apps to know which field your referencing, Value is the Value that is shown inside the List (if I'm not mistaking). Just use your ID for both Value and ID.

Was this reply helpful? Yes No