cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Dropdown selection updating ALL Data Cards

Hi,

I am very new to Power Apps so I apologize in advance if this is a silly question...

When I make a selection in my dropdown it updates ALL the data in every datacard with my selection!

 

2020-05-18.png2020-05-18 (1).png

My data is being pulled from Excel ...One Drive

 

Dropdown Formula

Items.....Distinct(Table1,Area)

Default.....Blank

 

Gallery Formula

Text.......Dropdown_Area.SelectedText.Value

 

I would like to just update the one relevant card in my dropdown when I make a selection in my dropdown and then update my spreadsheet!

 

I am not sure if more information is needed but please can someone help me with this as I have spent 2 days trying to figure this out and its probably a simple solution ....

Thanks in advance!!

 

 

5 REPLIES 5
eka24
Super User
Super User

Make your a Post a little clearer. Do you want to send the Data in the dropdown to the Excel.

------------

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.

Anonymous
Not applicable

Hi,

Thank for replying 

I want to be able to 

1) make a selection in my dropdown that

2) updates the “relevant“ data card (Asset Number) only in the gallery with the text I choose in my drop down AND

3) update my excel spreadsheet with the new data

 

hope that helps

I think that firstly I will need to match the 

eka24
Super User
Super User

If the Gallery and the dropdown are on the same screen:

 

Filter (Table1,Area=Dropdown_Area.Selected.Result)

------------

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.

 

Anonymous
Not applicable

The gallery is on a separate page to the details page.

 

i did try that formula though but it returned an error

 

2020-05-18 (2).png

If on different page, then at the start of the OnSelect of the Navigate button put:

Set(MySelected,Dropdown_Area.Selected.Result)

 

For instance if you have on navigation button: Navigate (Screen1) modify it to;

Set(MySelected,Dropdown_Area.Selected.Result); Navigate (Screen1)

 

Then Filter Gallery as;

Filter (Table1,Area=MySelected)

------------

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.

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,910)