Collecting data to add to an existing field using dropdowns to select...

[russparks]

Hello

I am not sure if this is possible but it seems it should be, if anyone can assist I would appreciate it.

I have a list of suppliers in different categories like this:

Trade	Name
Joinery	Stick Fix Ltd
Joinery	Trees Ltd
Plumbing	Pipez Ltd
Plumbing	Tanks Ltd
Plumbing	Boilers Ltd
Tiling	Ceramit Ltd
Tiling	Nice Wall Ltd

I want to be able to collect performance data (ratings and free text) on these suppliers from different members of my team, every month.  I want the ratings to be added to the particular supplier and not overwrite the existing record and I want to control the list of trades and suppliers centrally so my team are not typing them in each time.  In my ideal model, the record for 'Stick Fix Ltd', after a few months, would look like this (simplified):

Trade	Name	Comments	Rating	Date
Joinery	Stick Fix Ltd	Free text here	4.5/5	Jan 21
Joinery	Stick Fix Ltd	Free text here	4.2/5	Feb 21
Joinery	Stick Fix Ltd	Free text here	3.9/5	Mar 21

I want the user to be able to navigate by dropdown, clicking on trade and selecting Joinery, then selecting Stick Fix Ltd > Add New Rating.  I don't want the user to be able to add a new trade or supplier to the list.

Ideally, the records will be kept in Excel but at a push I could learn how Lists work if this was easier.  I have OneDrive and Sharepoint etc.

Thanks in advance 🙂

[RandyHayes · Accepted solution]

@russparks 

Yes, this is all very possible in PowerApps.  Have you started on this journey or are you just inquiring about the ability?

In general, you would have just as you mention - a Dropdown (or Gallery) of Trades and then a filtered dropdown (or Gallery) of the Names associated with the selected Trade.  You could then just have a simple EditForm (in New mode) to create a record in your Excel (yes, I would lean more to SharePoint, but you can use Excel) for their rating.

I hope this is helpful for you.

[russparks]

Hi @RandyHayes I was hoping this would be the case.  I will continue through the tutorials, currently at level 2 so a bit to go yet!  I am hoping your feedback on EditForm is a good point to start reserching 🙂

Russ

[RandyHayes]

@russparks 

Sounds good.  Just post again when you run into issue.

Also, on the subject of EditForms, you might want to take a look at my comprehensive video on EditForm - everything you ever wanted to know and some things you might not even have imagined.

[russparks]

Hi @RandyHayes thanks for the video, I worked through this and whilst it does write to the data source it replaces the record.  I need multiple records against each field.  I need to select the 1st dropdown which populates the 2nd dropdown then have a form to fill out that appends to the selection.

Russ

[RandyHayes]

@russparks 

Sorry for the delay on this response.

Can you describe a little more about what you mean in your last post?  Perhaps a screenshot or mockup of what you are trying to get to - if available.