web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Get options of column ...

Power Apps

Unanswered

Get options of column of sharepoint list on combobox

(0) Share

Report

Report

Posted on by lorodo

I've got this list that has the user mail as user datatype and a column also with user datatype, that has sharedmailboxes for the user in the record.

Captura de pantalla 2024-04-29 104342.png

I need to populate a combobox whitn the 'Buzones compartidos' elements.

The filter is the 'Asignado a' Email that I store in a var once the user has logged in the app.

I'm getting this result

Captura de pantalla 2024-04-29 104613.png

I've got a button to reset the collection wich has this function

----

ClearCollect(collGestores;

Filter(Gestores;ThisRecord.'Asignado a'.Email = varEmailUsuario));;

----

In the dropdown Items property I have this formula

----

Distinct(Table(ShowColumns(collGestores;'Buzones compartidos'));'Buzonescompartidos')

----

How can I get all values from the registry I'm filtering with the variable varEmailUsuario?

Thnx in advance!

Cheers!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @lorodo ,

Do you mean that values of 'Buzones compartidos' shows incorrectly in combo box? What is the type of 'Buzones compartidos' column?

Assuming that 'Buzones compartidos' is single line of text. Please try this if you want to populate values of 'Buzones compartidos' filtered by 'Asignado a'.Email = varEmailUsuario.

Items of combo box.

Distinct(Filter(Gestores;'Asignado a'.Email = varEmailUsuario);'Buzones compartidos')

Best regards,

Rimmon

Was this reply helpful? Yes No
lorodo on at

Like (0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft !
Thanx for your response.
'Buzones compartidos' column is a multivalue User datatype.
Your solution shows another integer on combo, but is not the solution I'm looking for.
As you can see, the 'Buzones compartidos' column has several values for each record.
The filter I'm currently using to populate, works fine, as the registry ID shows the row I want when showing the collection, but I'm trying to get all values from 'Buzones compartidos' as unique items in combo.
This is an example of the list i'm currently using.
Asignado a (User datatype) ID Buzones compartidos (Multi User datatype)
user1@mail.com 1
mailbox1@mail.com
mailbox2@mail.com
user2@mail.com 2
mailbox2@mail.com
mailbox3@mail.com
The user opening the app filters with the first row.
I want to populate the combobox with values
mailbox1@mail.com
mailbox2@mail.com
When pressing the button that filters, the ID is correct, but combo still shows an unknown integer.
The items parameter when hovering on combobox on edit view shows this, if it helps

Best regards,
Lorodo

Was this reply helpful? Yes No

Join the conversation