Natural Gas Bill Recorder (I'm not done coding the totals buttons because I'm having a Save Button issue....
I set the year... that works.
Can update every years month of January... that works.
BUT... Change the month & it saves all other months into Year #3???
I use these 3 buttons to set the year:
YEAR BUTTON 2018 : ONSELECT
Set(GasYear,"3");
UpdateIf(NG1,GasMonth="January",
{Year:'Year Dropdown'.Selected.'Garage Walls Attached'});
UpdateIf('Natural Gas 2',GasMonth="January",
{Year: 'Year Dropdown'.Selected.'Garage Walls Attached'});
UpdateIf('Natural Gas 3',GasMonth="January",
{Year:'Year Dropdown'.Selected.'Garage Walls Attached'})
GALLERY : Items
If(GasYear="1",NG1,If(GasYear="2",'Natural Gas 2',If(GasYear="3",'Natural Gas 3')))
GALLERY - Snapshot
GALLERY - LABEL (Blue Months Above) : OnSelect
ThisItem.GasMonth
SAVE BUTTON : ONSELECT
If(
Gallery1.Selected.Year = "1",
UpdateIf(
NG1,
Gallery1.Selected.GasMonth = GasMonth,
{
Provider: 'NG Provider'.Text,
Cost_GJ: 'NG Cost'.Text,
Monthy_GJ: 'NG How Many'.Text,
Admin_Fee: 'NG Admin'.Text,
Delivery_Fee: 'NG Delivery'.Text
}
),
If(
Gallery1.Selected.Year = "2",
UpdateIf(
'Natural Gas 2',
Gallery1.Selected.GasMonth = GasMonth,
{
Provider: 'NG Provider'.Text,
Cost_GJ: 'NG Cost'.Text,
Monthy_GJ: 'NG How Many'.Text,
Admin_Fee: 'NG Admin'.Text,
Delivery_Fee: 'NG Delivery'.Text
}
),
(UpdateIf(
'Natural Gas 3',
Gallery1.Selected.GasMonth = GasMonth,
{
Provider: 'NG Provider'.Text,
Cost_GJ: 'NG Cost'.Text,
Monthy_GJ: 'NG How Many'.Text,
Admin_Fee: 'NG Admin'.Text,
Delivery_Fee: 'NG Delivery'.Text
}
) )
)
)
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
181 | |
52 | |
41 | |
38 | |
32 |
User | Count |
---|---|
257 | |
81 | |
71 | |
69 | |
66 |