LookUp combobox field not saving to SharePoint

(0) Share

Report

Posted on by TRCReliability

I'm hoping someone can help me!

I have an a app that is tied to two SharePoint Lists

'Test Readiness' List:

ProjectNumber
ProjectDescription
ProjectType
Work Instructions (this is a lookup combobox to my WIs list. This combobox allows multiple choices and the search column is the title one)

My 'WIs' SP List columns:

Title
Name of WI
SUbsection

I have a new form save button, But i cant figure what form of patch should i use. I have this one but is obviously not working

Patch(
 'Test Readiness',
 Defaults('Test Readiness'),
 { 'Work Instructions':DataCardValue27.Selected.Títle})

Datacardvalue27 is the name of the datacard from the combobox. What would be the solution?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 155,352 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @TRCReliability ,

Assuming the Title field is the one being looked up in WIs,

Patch( 'Test Readiness', Defaults('Test Readiness'), { 'Work Instructions': { Value: DataCardValue27.Selected.Títle, Id: LookUp( WIs, Title = DataCardValue27.Selected.Títle ).ID } } )

but I am wondering why you are using a Lookup column then not simply using in the Items

Choices([@'Test Readiness'].'Work Instructions')

then your Patched value would simply be

DataCardValue27.Selected

or better still drop the lookup column for a Text field and simply Patch

DataCardValue27.Selected.Title

back to it.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
BhargavPatel 660 Moderator on at

Like (0)

Report
Copy link

Link copied!
Try this:
Patch( 'Test Readiness', Defaults('Test Readiness'), { 'Work Instructions':LookUp(WIs,ID = DataCardValue27.Selected.ID)})

Was this reply helpful? Yes No
TRCReliability 11 on at

Like (0)

Report
Copy link

Link copied!

It gives me the error:
"expected type Table, found type Record"

Was this reply helpful? Yes No
TRCReliability 11 on at

Like (0)

Report
Copy link

Link copied!
If i use this on my items property
Choices([@'Test Readiness'].'Work Instructions')
then using in my patch formula
DataCardValue27.Selected

It gives me the error:
"expected type Table, found type Record"

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

Like (0)

Report
Copy link

Link copied!

Hi @TRCReliability ,

Either your field is multi value and your combo box single selection or the reverse.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No