cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cotswoldmark
New Member

Access to PowerApps with Dynamic Combo boxes

Hi - I'm brand new to PowerApps...but have built simple apps in MS Access previously.

One Access app I created for our company enables a users to get quotes for a product, based on a number of criteria.

They choose criteria via combo boxes.  The list in the second combo box is sourced from a query and uses the critieria from the 1st combo.  This is repeated in subsequent combo boxes using data from the previous combos.

Finally I append the quote query result to a temp table (I do this in case the user wants to add multiple quotes)...a report is then shown.  On exit, data from the temp table is cleared, ready for the next quote

 

I was looking to roll this app out externally for our suppliers...and I've been advised that PowerApps is the way ahead.

 

Before I embark on a learning exercise - is this something that is possible in PowerApps?  I have had a play around with the UI - and sourced data from Excel tables...but the combos are therefore not dynamic based on the data selected in the other combos.

 

Hope this makes sense - sample of my attempt at a UI attached...

 

SW_Quote.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
v-monli-msft
Community Support
Community Support

Hi @cotswoldmark,

 

Can you first explain how you want the 2nd combo box to filter with the values selected from the 1st combo box? Maybe with example excel source data.

 

Here is my example to explain how to achieve this:

 

I have the excel table like below:

Capture.PNG

 

Insert the 1st ComboBox1 control. Set its Items property to:

 

Distinct(Table1,A)

 

 

Capture.PNG

 

Insert the 2nd ComboBox2 control, I assume that user will at most select 4 options in ComboBox1. But if yours have more option selected, you can just add more filter conditions. Set Items property to:

Filter(Table1,
First(ComboBox1.SelectedItems).Result=A
Or
Last(FirstN(ComboBox1.SelectedItems,2)).Result=A
Or
Last(FirstN(ComboBox1.SelectedItems,3)).Result=A
Or
Last(FirstN(ComboBox1.SelectedItems,4)).Result=A
).B

Here are the ComboBox2's option result when selecting options from ComboBox1:

1.PNG2.PNG

 

 

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
tchin-nin
Memorable Member
Memorable Member

Hi @cotswoldmark

 

PowerApps is not yet accessible to guest users, so unless your suppliers have a licensed account into your Office365 tenant, you won't be able to share your app with them.

I said "yet" because the community is pushing quite hard to have this sharing to external users feature, so it might come one day.

 

But, otherwise, your business requirements seems to be achievable in PowerApps. I would suggest you to consider some other Data source than Excel : SQL/CDS best options, SharePoint might be considered with some restrictions.

 

Cheers,

Théo 

v-monli-msft
Community Support
Community Support

Hi @cotswoldmark,

 

Can you first explain how you want the 2nd combo box to filter with the values selected from the 1st combo box? Maybe with example excel source data.

 

Here is my example to explain how to achieve this:

 

I have the excel table like below:

Capture.PNG

 

Insert the 1st ComboBox1 control. Set its Items property to:

 

Distinct(Table1,A)

 

 

Capture.PNG

 

Insert the 2nd ComboBox2 control, I assume that user will at most select 4 options in ComboBox1. But if yours have more option selected, you can just add more filter conditions. Set Items property to:

Filter(Table1,
First(ComboBox1.SelectedItems).Result=A
Or
Last(FirstN(ComboBox1.SelectedItems,2)).Result=A
Or
Last(FirstN(ComboBox1.SelectedItems,3)).Result=A
Or
Last(FirstN(ComboBox1.SelectedItems,4)).Result=A
).B

Here are the ComboBox2's option result when selecting options from ComboBox1:

1.PNG2.PNG

 

 

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (44,880)