Modifying multiple cells in 2 tables

(0) Share

Report

Posted on by Alexey_bot

Hello everyone

I'm trying to do some store application with power apps.

Idea is following, when you're clicking necessary item, detailed info is opening.

In this window you have to select person from drop down menu.

And by clicking Issue Out in table1 quantity should decrease by -1. In another table need to find cell which demonstrate that e.g. Alexey Ivanov received summer coverall and marking date of receipt.

Please advice how to make such functions with one button.

Here are example of tables used

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (0)

KvB1 1,596 on at

Like (0)

Report
Copy link

Link copied!
I am assuming that your picture is a gallery with the inventory table in the Items property, and that the 'Issue Out' is in this gallery.

Patch( Table1, ThisRecord, { qty: Value(ThisRecord.qty) - 1 } );;
This will decrease quantity by 1. If my assumption is false, you need to use a LookUp using the number.

Patch( Table2, LookUp( Table2, name=Dropdown1.Selected.Value ), { summercoverall: Today() } );;
This will look for the row with the name selected by the dropdown, then patch the date in the field of summercoverall. If you want to separate the columns keeping track of if he received item and when he received item, you should make a new column, but I hope you get the idea.

Was this reply helpful? Yes No
Alexey_bot 49 on at

Like (0)

Report
Copy link

Link copied!
Hello, is there possibility to define type automatically, e.g. if boots opened >then boots. if coverall > then coverall? As i understand here only coveral will be marked, and if there possibility to chose type for table 2 according chosen in table 1?
Patch( Table2, LookUp( Table2, name=Dropdown1.Selected.Value ), { summercoverall: Today() } );;

Was this reply helpful? Yes No
KvB1 1,596 on at

Like (0)

Report
Copy link

Link copied!

It is not possible to base the column that you want to patch on a dynamic value, eg a variable. It has to be a fixed value.

You can however use an If function on the Today(), to tell the formula that it only has to patch summercoverall if it is selected.

Was this reply helpful? Yes No
Alexey_bot 49 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much, please advice also is there possibility to change qty cell to selected value, e.g. issued boots were 2 or 3, and you need to write e.g. in form qty issued 2 and it will automatically decrease by 2. Is it possible?

Was this reply helpful? Yes No
KvB1 1,596 on at

Like (0)

Report
Copy link

Link copied!
Yeah sure, all you need then is a textinput control, and change the formula for table1 to
Patch( Table1, ThisRecord, { qty: Value(ThisRecord.qty) - Value(TextInput1.Text) } );;

Was this reply helpful? Yes No
Alexey_bot 49 on at

Like (0)

Report
Copy link

Link copied!

Thank you, and last question. Will it work if I open detail info for table 2 e.g. i will change names to colums and types in lines, then i ll open detail info for boots or smth other, and then with dropdown menu will chose column with name and make date stamp in cell. is it possible? as I understand it will be fixed value

Was this reply helpful? Yes No
KvB1 1,596 on at

Like (0)

Report
Copy link

Link copied!
No, but you can patch the column only if detail for that item is opened
Patch( Table2, LookUp( Table2, name=Dropdown1.Selected.Value ), { summercoverall: If(ItemDetail="summercoverall",Today(),NoChange), wintercoverall: If(ItemDetail="wintercoverall",Today(),NoChange), boots: If(ItemDetail="boots",Today(),NoChange) } );;

Was this reply helpful? Yes No
Alexey_bot 49 on at

Like (0)

Report
Copy link

Link copied!

Hello, i tried to input this formula to button, but it says me that "ThisRecord" is unknown name in formula, please advice how to solve it?

Was this reply helpful? Yes No
KvB1 1,596 on at

Like (0)

Report
Copy link

Link copied!

ThisRecord only works when refering to a record in a table (eg in a ForAll function, or in a gallery with a button for that record).

Which formula are you using on which button?

Was this reply helpful? Yes No
Alexey_bot 49 on at

Like (0)

Report
Copy link

Link copied!
I was tryig to use formula that you adviced
Patch( Table1, ThisRecord, { qty: Value(ThisRecord.qty) - Value(TextInput1.Text) } );;
I have a window with opened detailed information from table,(clicked on arrow), and i want by clicking this button change quantity for this record(increase). Window attached

Was this reply helpful? Yes No