Filter table within collection

[Hor]

Hi. I was working with the Org Browser template app and was having trouble displaying the "BusinessPhones" field in the app. It seems that "BusinessPhones" column comprises another Table which stores the value within. Does anyone know how can I display the phone number (value) that stored in this Table within this Collection?

[Danielle]

Ok great, now i have this

What's next? And should i untick 'BusinessPhones'?

[xzDan]

Can you make any button, and set its Onselect to

ClearCollect(Test_Tbl,AddColumns(EmployeeProfile,"Phone_Value",BusinessPhones.Value))

and then click it, and go to the Collection viewer, (click purple icon on very top-left) and see what is inside Phone_Value? I thought it would be just a number. It seems there is more information inside it, which I don't understand. You can try removing 'Business Phones' from the fields list

Edit:: Click File, not the purple icon.

[Danielle]

Ok so i added button and put

When i go to collections, there is a new one created 'text_tbl', however, there are no values in any of the fields

[xzDan]

Is your EmployeeProfile table blank?

[Danielle]

Hi,

No it isnt

[xzDan]

Ok, I have something very similar if I do

ClearCollect(EmployeeProfile,Office365Users.UserProfile("MyEmail"))

Again, what is it you get when you open BusinessPhones. Is it 1 number? Yes it is

I am not sure then sorry. I am finding that even doing BusinessPhones.Value is giving another record for me also.

You can also try doing

First(BusinessPhones).Value

Instead of

BusinessPhones.Value

[Danielle]

Hi,

That didn't work either. It got rid of the new collection all together. 

Thank you for your help though, i really appreciate it! : )

Have a good day!

Kind regards,

Danielle

[Danielle · Accepted solution]

Hi,

I figured out how to do it!

You can do it with a dropdown box. 

1. Insert dropdown box

2. In the Items tab input: First(YOUR COLLECTION NAME).BusinessPhones)OR WHATEVER VALUE YOUR OFFICE NUMBERS ARE UNDER).

So for me my collection is employeeprofile and my value for office numbers is BusinessPhones

so it looks like this First(EmployeeProfile).BusinessPhones

Thanks again for your help! I hope this helps you!

Kind regards,

Danielle

[Hor]

Hi the formula i added is 
If(IsBlank(First(EmployeeProfile).BusinessPhones),"-",First(First(EmployeeProfile).BusinessPhones).Value)

[Danielle]

Hi, Now i am having another problem. Our employee database doesn't show peoples managers, however, we have a (empty) manager collection so it is automatically trying to pull that information in. I keep receiving this error message. Could someone please explain how i can stop this error message from popping up? 

The error message is: 

Office365Users.Manager failed: { "status": 404, "message": "No manager found for the specified user.\r\nclientRequestId: c5914d07-82d0-48b0-91ab-a76fed9ea34c", "source": "office365users-ase.azconn-ase.p.azurewebsites.net" }

Kind regards,

Danielle