Access to PowerApps with Dynamic Combo boxes

[cotswoldmark]

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...

[tchin-nin]

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 · Accepted solution]

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:

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

Distinct(Table1,A)

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:

Regards,

Mona