Power Platform Community Forum Thread Details

Hello,

I have an app which collects some pieces of information and then concurrently patches it over to two sharepoint lists. The formula is as follows:

Concurrent(
 If(
 tglDefuelRequest,
 Patch(
 FuelResources,
 LookUp(FuelResources, ID = Max(Filter(FuelResources, Title = "Reclaim", Location.Value = varLocation), ID)),
 {
 Fuel: Value(lblFuelRemaining.Text)
 }
 ),
 Patch(
 FuelResources,
 LookUp(FuelResources, ID = Max(Filter(FuelResources, Title = lblResource.Selected.Value, Location.Value = varLocation), ID)),
 {
 Fuel: Value(lblFuelRemaining.Text),
 CurrentMeter: Value(entMeterOut.Text)
 }
 )
),
Patch(
 varLocation,
 Defaults(varLocation),
 {
 Vehicle: entTailNumber.Text,
 Resource: entResource.Selected.Value,
 Initials: entInitials.Text,
 Used: Value(entFuelUsed.Text),
 MeterIn: Value(entMeterIn.Text),
 DiscrepancyReason: entDiscrepancy.Text,
 Defuel: If(entDefuelRequest, true, false),
 MeterOut: Value(entMeterOut.Text)
 }
)
);

What's weird is everything, every single time, in the second patch going to the list 'varLocation' gets posted with no problem.

The first patch to 'FuelResources' also works but not 100% of the time:

 {
 Fuel: Value(lblFuelRemaining.Text),
 CurrentMeter: Value(entMeterOut.Text)
 }

CurrentMeter will get posted with any issue, but Fuel: for some reason doesn't. Like so:

I even tried making a second column as text only instead of a number to see if it was an issue with sharepoint not accepting the datatype but even that sometimes doesn't always get posted either.

The formula for lblFuelRemaining is as follows:

If(
 tglDefuelRequest,
 Round(Value(LookUp(FuelResources, ID = Max(Filter(FuelResources, Title = "Reclaim", Location.Value = varLocation), ID), Fuel) + Abs(lblFuelUsed.Text)), 1),
 Round(Value(LookUp(FuelResources, ID = Max(Filter(FuelResources, Title = lblResource.Selected.Value), ID), Fuel) - entFuelUsed.Text),1)
)

It basically looks up what the current volume is in the truck, subtracts the amount of fuel dispensed from that and then displays the value to the user.

As far as I know (at least nobody has reported it) no errors are displayed during the patching process. So I'm not really sure what's going on and why that one single field doesn't get posted while everything else does.

Any help will be greatly appreciated! Thank you!

Categories:

Building Power Apps