Unanswered

DropDown List Based on 2 Share Point List

(0) Share

Report

Posted on by Omer_K

Hello everyone,
I have a list in Share Point called Share Point 1
Whose has columns of countries and fruits
I have already created an app that has a drop down list of country and fruit name and need to enter quantity (Unit)
When I click Finish - it moves the data to a list called Share Point2 (By using patch function)
The thing is that if I entered a number of fruits from a certain country - I would like to know how the list in the app will show only the fruits that I did not enter to that country,
According to the picture, if I choose Italy in the drop-down list, only the banana and watermelon will be displayed:

Power Apps.png

Thanks 🙂

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Omer_K ,

Use this in items property of fruits dropdown:

With( {alreadySelectedFruits: Filter(List2,Country=CountryDropDown.Selected.Value), existingFruits: Filter(List1,Country=ContryDropDown.Selected.Value) }, Filter(existingFruits,!(Fruit in alreadySelectedFruits.Fruit).Fruit )

Hope it helps !
Omer_K 57 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Gabi 🙂
Thank you so much 🙂
if I would like to see all the fruits that not selected in the gallery in the Check Box list - how do I adjust the formula?
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Can you show me a screen capture, to figure it out what you want to accomplish ?
Omer_K 57 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Gabi 🙂
First of all - thanks for the help 🙂
According to the picture I attached,
If I chose the app in Italy - in the gallery (I called it FruitGallery) I will have a Check Box of the fruits that are not in Share Point List 2 and then I can select them as required