Power Platform Community Forum Thread Details

Hello,

Trying to build an 'inventory list' to track items basically. For this, i am certain my current process is flawed and was hoping someone may be able to point out my issues. Sometimes the trailer when 'swapped' is pulling incorrect info and rather slow to update. Hoping it is something simple I am overlooking? It currently works - although is slow and my current formulas are pretty error prone. I am hoping someone out there is able to help simplify the process and make it work better?

Currently, the drop downs concencate any other 'door' that currently has a trailer value as "OPEN" to find the correct trailer based on ID

Basically, each item has its own submit button and code is as follows

DropDown

If('374B1'.Text = "OPEN", Distinct(Filter('Trailer Tracking', Trailer.Value <> "OPEN"),Concatenate(Building.Value," - ", Dock.Value," - ", Trailer.Value," - ", Comments, Text(ThisRecord.ID))),Distinct(Filter('Trailer Tracking',Trailer.Value="OPEN"),Concatenate(Building.Value," - ", Dock.Value," - ", Trailer.Value, " - ", Comments, Text(ThisRecord.ID))))

Submit Button

ClearCollect( TrailerSwap,
 { 
 SelectedBuilding: Trim(First(FirstN(Split('374B1Choice'.Selected.Result, " - "),1)).Result),
 SelectedDock: Trim(Last(FirstN(Split('374B1Choice'.Selected.Result, " - "),2)).Result),
 SelectedTrailer: Trim(Last(FirstN(Split('374B1Choice'.Selected.Result, " - "),3)).Result),
 SelectedComments: Trim(Last(FirstN(Split('374B1Choice'.Selected.Result, " - "),5)).Result),
 SelectedID:Trim(Last(FirstN(Split('374B1Choice'.Selected.Result, " - "),4)).Result),
 CurrentID: LookUp('Trailer Tracking', '374B1'.Text = Trailer.Value , ID),
 CurrentTrailer: '374B1'.Text,
 CurrentBuilding: LookUp('Trailer Tracking', '374B1'.Text = Trailer.Value, Building.Value),
 CurrentDock: LookUp('Trailer Tracking', '374B1'.Text = Trailer.Value, Dock.Value),
 CurrentInspection: LookUp('Trailer Tracking', '374B1'.Text = Trailer.Value, 'Inspection Date'),
 CurrentComments: LookUp('Trailer Tracking', '374B1'.Text = Trailer.Value, Comments)
 } 
);

Patch('Trailer Tracking', LookUp('Trailer Tracking', Text(ID) = First(TrailerSwap).SelectedID),
 {Dock: {Value: First(TrailerSwap).CurrentDock}},
 {Building: {Value: First(TrailerSwap).CurrentBuilding}},
 {Status: {Value: Dropdown374B1.Selected.Value}},
 {Comments: First(TrailerSwap).CurrentComments}
);

Patch('Trailer Tracking', LookUp('Trailer Tracking', ID = First(TrailerSwap).CurrentID),
 {Dock: {Value: First(TrailerSwap).SelectedDock}},
 {Building: {Value: First(TrailerSwap).SelectedBuilding}},
 {Status: {Value: Dropdown374B1.Selected.Value}},
 {Comments: First(TrailerSwap).SelectedComments}
);

Categories:

Building Power Apps