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

(0) Share

Report

Posted on by 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 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
russparks 18 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
russparks 18 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No