Hello All,
I have built an expense app for employee business trips. I have 2 sharepoint lists, Expenses & Line Items. The Line Items sharepoint list has a lookup column called ExpenseID that matches the line item to the expense. When I first built my app, I had a lookup column named 'Expense Reference' in the line items sharepoint list. This matched the line item to the expense by title. This ended up being a problem because if they entered the same title for 2 different trips, then the line items would look the same. So I switched it to lookup by id. My problem now is since I made that switch, when I go to add a new line item for an expense and press save, it no longer automatically updates the look up column. So on my screen with the expenses and line items, the line items do not show up. It was working perfectly before, and I went through the entire app and updated all my formulas once I changed the lookup column. Any thoughts?
Expense Gallery Items Property: varcurrentItem
Line Items Gallery Items Property: Filter('Line Items', ExpenseID.id = varcurrentItem.ID)
ExpenseID Data Card Default Property:
{
'@odata.type': "#Microsoft.Azure.Connectors.Sharepoint.SPListExpandedReference",
ID: varcurrentItem.ID,
Value: varcurrentItem.ID
}
Save Button: SubmitForm(Form1);Navigate(DetailScreen)
