Answered

Sharepoint list lookup column to allow multiple value - default property in powerapp error

(0) Share

Report

Posted on by dougyk23

Hello,

I'm starting to learn PowerApps and created a couple of sharepoint lists as the datasource. One list is called "Warranty" where I have a lookup column to another list called "PaymentType'. The look up column allows multiple values and is called "PaymentType_lkup".

When I create the powerapp, I used the 'start from data' option and selected the warranty SP list as the data source. Then made the connection to the paymenttype list as well.

The 'premade' app has an error on the default property of the lookup field "PaymentType_lkup", which is set to ThisItem.PaymentType_lkup

The error is "Expected Record value. The property on this control expects Record values. The rule produces Table values which are incompatible".

Looking through some forums, it looks like I need to use the concat function in the default field, since I allow multiple values ,but I can't seem to figure out the formatting.

Any assistance is appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @dougyk23 ,

Could you please share your layouts of the APP？ Have you modified any controls or properties after creating the APP?

I assume that you have added a control like Label and want to display the PaymentType field’s value.

The “PaymentType_lkup” field is a LookUp field and allows multiple values, it means the field stores a table with one column of multiple records displayed. If you want to display the values in the Label of the Gallery, you could modify the Default property of the Label to:

Concat(ThisItem.PaymentType_lkup, Value, ",")

In addition, if the issue occurs in the forms, you could remove and re-add the cards to correct them.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Verified answer

dougyk23 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the quick reply. I ended up starting over and when I added the paymenttype_lkup field to the form, it started working. I must have accidentally put something in the default property of that card. Honestly not sure. I've got a lot of learning to do but again I appreciate the response!

Was this reply helpful? Yes No