ID filter

(0) Share

Report

Posted on by Ben-00-38

176

Hello,
I have 2 galleries:
Adress

Filter('Compte client - adresse'; compte = varSelected.'ID (Title)')

Contact

Filter('Compte Client - contact'; Title = varSelected.Title)

in the dropdown (N °) of the contact gallery,
I wrote this formula but it shows all the results of the item ID.
I want the dropdown to only display the ID values linked to the account.

can you help me write the right code.

Distinct('Compte client - adresse'; ID)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

v-xiaochen-msft on at

Like (0)

Report

Hi @Ben-00-38 ,

I don't quite understand this sentence.

What's account ?

What is the relationship between the ID of this record and account?

Best Regards,

Wearsky

Was this reply helpful? Yes No
Ben-00-38 176 on at

Like (0)

Report

in adress
compte = thisitem.compte
N° = thisitem.ID

in contact
N° display item ID of adress.
i want filter with not all value, but only item ID = thisitem.compte

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @Ben-00-38 ,

I still don't know your needs.

What's your datasourse? Is it a sharepoint list?

Is there any relationship between these two tables?

In addition, I suggest you use some pictures to describe what you want the result to be.

Best Regards,
Wearsky

Was this reply helpful? Yes No
Ben-00-38 176 on at

Like (0)

Report

i want display in site relationship between ID adress and compte value

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (0)

Report
Hi @Ben-00-38 ,

So, if compte=3, do you want Dropdown to display 38, 48, 49 instead of 38, 42, 48, 49?

If so ,you could try this formula on Items property of dropdown control:

Filter('Compte client - adresse';compte= ThisItem.compte).ID

If you want to remove duplicate values, you could use the Distinct function again.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Ben-00-38 176 on at

Like (0)

Report
thank you so much ! 😀
Filter('Compte client - adresse';compte= ThisItem.Title).ID

Was this reply helpful? Yes No