Answered

Sharepoint LIst {object] issue

(0) Share

Report

Posted on by rosscortb

196

My table is linked to a sharepoint list - ReserchStudies. I read that you add a column to overcome the [object] issue but struggling to get it to work? The brand column is a lookup in the sharepoint list

Any ideas?

Thanks

Ross

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @rosscortb ,

I assume you have a multi-value choice/lookup columns there - if so

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

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
rosscortb 196 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz Thanks Warren.

Are you able to help with the second part please.

1. I want to add a dropdown with the brand names that will filter the table.
I never built the sharepoint site, but the table is looking at Reseach Studies. Inside there is a column called Brand which is a look up that seems to be coming from list called Research Brand.

for the dropdown I have =
Distinct('Research Brand',Name)

2. I want to add a "Please select" to the dropdown.

Thanks
Ross

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @rosscortb ,

You probably need this

Filter( 'Research Studies', Brand.Value = Dropdown6.Selected.Value )

I will also offer another piece of advice - SharePoint Lookup columns are generally completely unnecessary and can can unwanted complexity and restrictions for you. I never use them.

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
rosscortb 196 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz Thanks. I don't get the option to use Brand.Value for some reason.

Thanks
Ross

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @rosscortb ,

That is a Delegation warning, not an error. If you Combo Box is Single Selection it would be

Filter( 'Research Studies', Dropdown6.SelectedItems in Brand.Value )

but it is still not Delegable.

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