How to filter dropdown(collection) on regarding field

(0) Share

Report

Posted on by H V

1,510

Hi,

I have taken two drop-downs. one for accounts and another for appointments. Now, I want to display all the appointment(related to selected account in regarding field) of selected account in first dropdown.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Try
Filter (Datasource,Column=dropdown1.Selected.Value)

Showing the Items on the dropdown Will help
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@hardikv

There's no information here about where your data is coming from or what formulas you used so far so I had to take a few guesses. Please provide any relevant info.

Distinct(Filter(your_datasource_name, Accounts = Dropdown_Accounts.Selected.Value), Appointments)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
H V 1,510 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I'm using CDS data source for both entity(Account & Appointment).

I have put below code on 'items' property for Appointment, but it doesn't work.

Filter (Appointments,Regarding = Dropdown1.Selected.Value)

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

If you try the solution by @mdevaney and still have issues, show the items property of the two Dropdowns
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi@dynamics-power,

Based on the issue you mentioned, you want to display appointments of selected accounts.

Considering you use CDS data source for both entities (Account & Appointment), let me explain that Regarding fields is a special type which is a Customer LookUp field. It can refer to a record from either Account or Appointment.

Therefore, please share more about your "Regarding" and what is your relationship in it.

Here is an article you can check for details about regarding field:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-references

Best Regards,
Qi Qiao

Was this reply helpful? Yes No