HI,
So it looks like when I Monitor the app, the per diem rate control which shows blank on the screen, is giving a message:
The per diem rate is a control that pulls the per diem rate from an excel file based off of the zip code and meal selected. I think the formula is what is causing the values to disappear, because within my Table, the data is showing fine. But in the editable grid, the per diem rate disappears.
Per Diem Rate Default Property:
Text(If(
//ThisItem.'Event Lookup:Location of Event'.Value= Blank() &&
varRecord.'Event Campus'.Value = "Other", ThisItem.'Per Diem Rate',
With(
{
// Perform the lookup once to get the relevant row in collection
Meals: LookUp(
colPerDiemRate,
ThisItem.'Event Lookup:Event Zip Code'.Value = 'Zip Code'
)
},
// Use Switch to determine which value to retrieve
Switch(
dpdRequiredMeals.Selected.Value,
"Breakfast",
Meals.'Breakfast ',
"Light Refreshments",
Meals.'Light Refreshments',
"Lunch",
Meals.Lunch,
"Dinner",
Meals.Dinner
)
)
//(Text(ThisItem.'Per Diem Rate',"[$-en-US]$ ###,##0.00"))
),"[$-en-US]$ ###,##0.00")
Per Diem Rate OnChange Property:
Select(btnUpdate)
btnUpdate OnSelect Property:
Patch('Checklist Details',ThisItem,{
Title: txtTitle.Text,
'Event Date': EventDate.SelectedDate,
'Event Zip': txtEventZip.Text,
'Required Meals': dpdRequiredMeals.Selected,
'Event Duration (HH:MM)': Value(txtDuration.Text)//,
//'Per Diem Rate': Value(txtPerDiemRate.Text)
//'Per Diem Total': txtPerDiemTotal.Text
//'Total Attendees': txtTotalAttendees.Value
});
If(
IsBlank(
LookUp(
colAddMealsUpdates,
ID = ThisItem.ID
)
),
Collect(
colAddMealsUpdates,
ThisItem
)
);
UpdateIf(
colAddMealsUpdates,
ID = ThisItem.ID,
{
Title: txtTitle.Text,
'Event Date': EventDate.SelectedDate,
'Event Zip': txtEventZip.Text,
'Required Meals': dpdRequiredMeals.Selected,
'Event Duration (HH:MM)': txtDuration.Text,
'Per Diem Rate':Value(txtPerDiemRate.Text),
'Per Diem Total': Value(txtPerDiemTotal.Text),
'Total Attendees': txtTotalAttendees.Value
}
);
ClearCollect(
colPerDiemRate,
Table1
);
/*With(
{
// Perform the lookup once to get the relevant row in collection
Meals: LookUp(
colPerDiemRate,
ThisItem.'Event Lookup:Event Zip Code'.Value = 'Zip Code'
)
},
// Use Switch to determine which value to retrieve
Switch(
dpdRequiredMeals.Selected.Value,
"Breakfast",
Meals.'Breakfast ',
"Light Refreshments",
Meals.'Light Refreshments',
"Lunch",
Meals.Lunch,
"Dinner",
Meals.Dinner
)
)*/
