cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Super User III
Super User III

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
Super User III
Super User III

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

Super User III
Super User III

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

Thank you - that worked.

Thanks Eka, will take a watching

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (88,989)