Power Platform Community Forum Thread Details

Hi,

I´m using a sharepoint list with the following structure, and I´m getting some issues with the code.

I´m filtering based on the Name, Location and Indication and I want the users to be able to select the month ant then insert the values for New, Decom and Identified. Also I´m doing a calculation, New - Decom= , and inserting that value in the specific cell based on all those filters applied before.

I´ve been able to make it work but using the New, Decom and Identified as the initial selection and then having the users inserting the value for each month. But, to facilitate the work of the users, i want to have them selecting the month and then inserting the values for the 3 fields.

Name	Location	CODE	Indication	Status	2019	2020	2021	2022	Jan.	Feb.	Mar.	Apr.	May	June	July	Aug.	Sept.	Oct.	Nov.	Dec.	Total	ID	Item Type	Path
John	Texas	1	OP1	New	10	12	4	8	6	7	8	12	5	4	6	7	8	9	0	9	81
John	Texas	2	OP1	Decom	12	5	6	7	8	8	9	0	3	2	1	12	4	5	3	3	58
John	Texas	3	OP1	Identified	20	1	5	6	7	8	9	8	9	0	7	65	3	3	4	5	128
John	Texas	4	OP1	Total	-2	7	-2	1	-2	-1	-1	12	2	2	5	-5	4	4	-3	6	23
John	Texas	5	OP2	New
John	Texas	6	OP2	Decom
John	Texas	7	OP2	Identified
John	Texas	8	OP2	Total
John	Texas	9	OP3	New
John	Texas	10	OP3	Decom
John	Texas	11	OP3	Identified
John	Texas	12	OP3	Total
John	Texas	13	OP4	New
John	Texas	14	OP4	Decom
John	Texas	15	OP4	Identified
John	Texas	16	OP4	Total
Mark	California	17	OP1	New
Mark	California	18	OP1	Decom
Mark	California	19	OP1	Identified
Mark	California	20	OP1	Total
Mark	California	21	OP2	New
Mark	California	22	OP2	Decom
Mark	California	23	OP2	Identified
Mark	California	24	OP2	Total
Mark	California	25	OP3	New
Mark	California	26	OP3	Decom
Mark	California	27	OP3	Identified
Mark	California	28	OP3	Total
Mark	California	29	OP4	New
Mark	California	30	OP4	Decom
Mark	California	31	OP4	Identified
Mark	California	32	OP4	Total

UpdateContext({
selectedRecord: LookUp(
'DBHardware',
Name = Dropdown_Name.Selected.Result &&
Location = Dropdown_Location.Selected.Result &&
Indication = Dropdown_Indication.Selected.Result
)
});

Set(
selectedMonth,
Dropdown_Month.Selected.Value
);

Patch(
'DBHardware',
selectedRecord,
{
[selectedMonth]: If(
StatusDropdown.Selected.Value = "New",
Value(TextInput_New.Text),
If(
StatusDropdown.Selected.Value = "Decom",
Value(TextInput_Decom.Text),
If(
StatusDropdown.Selected.Value = "Identified",
Value(TextInput_Identified.Text),
[selectedMonth]
)
)
),
'Total': If(
StatusDropdown.Selected.Value = "New" || StatusDropdown.Selected.Value = "Decom",
Sum('DBHardware'[selectedMonth]) + Value(TextInput_New.Text) - Value(TextInput_Decom.Text),
Sum('DBHardware'[selectedMonth])
)
}
)