cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Updating values from one list into a master list

Hello,

 

I know this is probably very basic but I'm very much learning. After some searching and watching videos, I can't quite work this out and would appreciate any help.

 

I have 2 lists. My primary to hold my commission data collected and a secondary to hold a lookup list of the commission type and percentage for each one.

 

Primary List:

Salesman Name

Customer Name

Order Value £

Commission Type

Commission %

 

Secondary List:

Commission Type

Commission %

 

As the Commission Type and Commission % are linked together and fixed, they could be entered in a mismatch if they were picked individually (plus you would have to remember what percentage went with which product hence I have them in a second list)

 

Trainer 8%

Jumpers 10%

Hats 5

 

On my App I have added type and percentage as a data table from my secondary list (see attached screenshot) and that's fine but where I am stuck is how to take those 2 selected values pulled in from my secondary lookup list and write them back into the type and percentage field in my primary list.

 

Any help really appreciated.

Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Updating values from one list into a master list

Hi @richrich123 ,

I picked your post up from the unanswered list and will try to help you.

So what you are trying to do is put the commission % from the second (I presume reference) list when you edit or create a new record in the first list based on the commission type selected in that list?

Firstly, a lookup will get the figure for you, we just need to decide when and how you use this (the below is for a DropDown/ComboBox)

Lookup(
   'Secondary List',
   'Commission Type' = <Your control name>.Selected.Value,   //.Value could be different
   'Commission %'
)

Please send me screen shot and some details of the field, control and list names.

 

View solution in original post

4 REPLIES 4
Highlighted
Super User III
Super User III

Re: Updating values from one list into a master list

Hi @richrich123 ,

I picked your post up from the unanswered list and will try to help you.

So what you are trying to do is put the commission % from the second (I presume reference) list when you edit or create a new record in the first list based on the commission type selected in that list?

Firstly, a lookup will get the figure for you, we just need to decide when and how you use this (the below is for a DropDown/ComboBox)

Lookup(
   'Secondary List',
   'Commission Type' = <Your control name>.Selected.Value,   //.Value could be different
   'Commission %'
)

Please send me screen shot and some details of the field, control and list names.

 

View solution in original post

Highlighted
Super User III
Super User III

Re: Updating values from one list into a master list

Will this video may help if you have not seen it already. Daniel Christian
https://youtu.be/gRAnpZJESiE
Highlighted
Helper I
Helper I

Re: Updating values from one list into a master list

Thank you - that worked.

Highlighted
Helper I
Helper I

Re: Updating values from one list into a master list

Thanks Eka, will take a watching

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

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

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,537)