Unanswered

Patch collection calculated Field

(0) Share

Report

Posted on by Will30

In my gallery for repeating tables, I have a label for a calculated field (I tried a text input but got the same result). This field calculates the Rate and checks a Yes/No field. If the Yes/No field is Yes, then the rate is the Rate * .75, othewise it is just the Rate. When running the app, it works, but when patching to the temporary gallery, the field show 0 when looking at the collections.

The formula in the OnSelect is:

Patch(
RequestCollection,
ThisItem,
{
PerDiemDate: dtePerDiemDate.SelectedDate,
Location: txtLocation.Text,
PerDiemRate: Value(txtPerDiemRate.Text),
JobName: drpJobName.Selected.Value,
Notes: txtNotes.Text,
TravelDay: drpTravelDay.Selected.Value,
Reimbursement: Value(lblReimbursementCalculated.Text),
CompanyHousing: drpCompanyHousing.Selected.Value,
CompanyCar: drpCompanyCar.Selected.Value
}
);

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Geeks_D 1,169 on at

Like
a
(0)

Report
Copy link

Link copied!

For the Calculated field when yes use - Value((Rate) * 75)

Was this reply helpful? Yes No
Will30 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, I am still new to this. The current formula is:

If(
Value(ThisItem.PerDiemRate) <> 0 && ThisItem.TravelDay="Yes",
Value(ThisItem.PerDiemRate) * .75,
Value(ThisItem.PerDiemRate)
)

Plus in the entry row the calculation does not show up until the Save button is selected. But again, it does not show up in the collection view.

Was this reply helpful? Yes No
Geeks_D 1,169 on at

Like
a
(0)

Report
Copy link

Link copied!

Try this
If(
(Value(ThisItem.PerDiemRate) <> 0 && ThisItem.Selected.TravelDay.="Yes"),
Value(ThisItem.PerDiemRate) * 0.75,
Value(ThisItem.PerDiemRate)
)

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Geeks_D ,

Few doubts:
1. Have you added the label in your gallery to store value and its not stored in your datasource, correct?
If yes, then you need to add the label column using 'AddColumns' so the value will be inserted in your collection.

2. When you say calculated, its your custom calculation, right. If its the calculated type (considering dataverse) it calculates automatically when content is saved.

Hope this helps

Was this reply helpful? Yes No
Will30 on at

Like
a
(0)

Report
Copy link

Link copied!

Did not work. Same Result

Was this reply helpful? Yes No
Geeks_D 1,169 on at

Like
a
(0)

Report
Copy link

Link copied!

I assumed the label is already in the gallery which checks each item for the checkbox value to perform the cal

Was this reply helpful? Yes No
Will30 on at

Like
a
(0)

Report
Copy link

Link copied!

I posted this. I think this would fix the issue but not sure how to do it:
Update a colum based on another column
What do you think?

Was this reply helpful? Yes No