Solved: Using data from Sharepoint list in Table view in P...

R4ffen · ‎03-25-2020

Hi, I am using a (one) multiple select coloumn in the list like "select what cars you have?" where the selected could be for example BMW and Toyota. The result in Powerapps table view is [object object] and I have understand that this is how it works. There are some workaround described on net, but I cant figure out how to get this to work. Could anyone describe this to a novice? Where do I put what code? Lets say that the list name in SP. is Carowner, the colomn with car choice name is cars.

Is it possible to get it to show BMW, Toyota (or BMW and Toyota) instead of [object object]?

Appriciate any answer.

v-bofeng-msft · ‎03-26-2020

Hi @R4ffen ：

Can you tell me:

Does your data sheet look similar to the picture below?

I think your problem is caused by data type mismatch.

[object object] represent that the field’s data type is “table” which is not available in data table control.

I think you can solve it by converting the data type of “cars”.

In this case, we can use Concat function to concatenate the values in the table into a string.

I’ve made a test for your reference:

Set the cars column’s Text property to:

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

Best Regards,

Bof

View solution in original post

v-bofeng-msft · ‎03-26-2020

Hi @R4ffen ：

Can you tell me:

Does your data sheet look similar to the picture below?

I think your problem is caused by data type mismatch.

[object object] represent that the field’s data type is “table” which is not available in data table control.

I think you can solve it by converting the data type of “cars”.

In this case, we can use Concat function to concatenate the values in the table into a string.

I’ve made a test for your reference:

Set the cars column’s Text property to:

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

Best Regards,

Bof

R4ffen · ‎03-26-2020

Hi, yes, my data looks the same. I got the code to work but had to change it a bit. Concat(ThisItem.cars;Value;",") worked. 2 of the , (commas) had to be changed to ; or it didnt work in my Powerapps... Is there any explanation why this?

Thank you very much!! Now Im happy 😁

v-bofeng-msft · ‎03-26-2020

Hi @R4ffen ：

In some region, “;” represent “,”, “;;”, represent “;”.

I think this link will help you a lot:

Operators and Identifiers in Power Apps:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/operators

Best Regards,

Bof

Anonymous · ‎04-09-2020

Hi. I am very new here and do not know yet how to post my own question.

I am having a very similar issue with my PowerApp. I have a collection that I am trying to reference, but get [Object object] back when I try to read the values in the collection.

The collection is called OrderItems. In this collection I have three values that I would like to read: ItemCost, ItemName and ItemQuantity (which are tables in the collection)

If I open any of the tables, there are more tables.

Please help