Unanswered

Form field value based on lookup list, filters another lookup field with matching value of previous field selected

(0) Share

Report

Posted on by Gerries

Good day all

I am fairly new to Power apps and have a simple canvas app with a gallery on the left and a form on the right. Two of the fields on the right namely (Department and Section) are lookup fields. These lookup fields is from another list, however each section has multiple lines with relevant sections.

Issue1: Duplicate values displayed on drop down in form.

(I have tried the below and the list then only displays distinct departments however when I submit form the value ignores the selected department and save a blank value)

Distinct(Choices('PrimaryList'.Department), Value)

Question: How do I ensure the value selected is save when I submit the form?

Issue 2:

When I select the department, I would to only display the matching sections from the lookup list in the sections field on the list.

Currently it the displays the whole list of available sections in the list.

I was thinking of using a filter but not sure how or if this is the best approach?

Please help me?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Zacharie_Cortes 170 on at

Like (0)

Report
Copy link

Link copied!

Have you tried :
ForAll(Distinct(Choices('PrimaryList'.Department), Value),{'PrimaryList':Value}) ?

Was this reply helpful? Yes No
Gerries 14 on at

Like (0)

Report
Copy link

Link copied!

Hi @Zacharie_Cortes

I assume this is for my Issue 1 listed?
I just tried it, it allows me to select the distinct departments in the list but does not save when I submit form.

Was this reply helpful? Yes No
Zacharie_Cortes 170 on at

Like (0)

Report
Copy link

Link copied!

Yes it war for the first issue.
For the second you can use a filter

Was this reply helpful? Yes No
Gerries 14 on at

Like (0)

Report
Copy link

Link copied!

Ok thanks, but how do I get the department selected to save when I submit form?

Could you please provide more details on how to setup the filter for my second issue?

Was this reply helpful? Yes No
Zacharie_Cortes 170 on at

Like (0)

Report
Copy link

Link copied!

it should save corectly now. If not, explain me more how do you save the whole thing

Was this reply helpful? Yes No
Gerries 14 on at

Like (0)

Report
Copy link

Link copied!

It doesn't save. I have a form based on a main list. Two of these column's are lookup fields to another list.
These one columns is called "Department" and the other is called "Section"
I have "new" and "edit" buttons created. So when I click on new button I can add a new record, when I get to department I can select the department and I only see one record because of the distinct function but when I save (Submit form) using a save button it doesn't save the selected department value, on the list the department field is blank. If I remove the distinct function it saves but then I see the duplicates of departments because one department is linked to multiple sections.

Was this reply helpful? Yes No
Gerries 14 on at

Like (1)

Report
Copy link

Link copied!
On department DataCardValue under Items I have this:

ForAll(Distinct(Choices([@'HR Inquiries - Tracker'].Department), Value),{'HR Inquiries - Tracker':Value})

But it doesn't save, when I select a department and then submit form.

Was this reply helpful? Yes No