Power Platform Community Forum Thread Details

Hello all,

I need to create a drop-down component with a list of filtered users coming from a dataverse table.

My dataverse table is the following :

the names of the fields in my table are as follows :

IDPerson (Primary key)
Name
Surname
Email
IsEmploye (boolean)

Before trying to filter my table, I just tried to get some records using the following formula :

ClearCollect( Employes;
 Table(
 { IDPerson: GBJB-Personen[@IDPerson]; Nom: GBJB-Personen[@Name]; Prenom: GBJB-Personen[@Surname]; GBJB-Personen[@Email]} ))

but this is not correct. So I tried the following :

ClearCollect( Employes;
 Table(
 { IDPerson: [@GBJB-Personen].IDPerson; Nom: [@GBJB-Personen].Vorname}; Prenom: [@GBJB-Personen].Nachname} ))

but it's wrong, too

I'm still searching on my side but if you've an idea ; here's what I should do:

retrieve the following fields from my table GBJB-Personen :

IDPerson ; Name ; Surname ; Email

where the field IstMitarbeiter = true

Someting like ..

ClearCollect(Employes,
 ShowColumns(
 Filter([@GBJB-Personen].'istMitarbeiter'=true);
 [@GBJB-Personen].'PersonID';
	[@GBJB-Personen].'Name' ;
	[@GBJB-Personen].'Surname'
 )
)

I'll then create a drop-down list with that collection

Thanks to all for your help 🙂

m look

Categories:

Building Power Apps