The app record navigator is on the right. The commitments are grouped by Type and the label shows the name. OnSelect runs a lookup to set the form records:
These are the item in the gallery:
Filter(Commitments, 'Commitment Item'=ThisItem.CommitmentItem)
These are the items of the parent Gallery:
AddColumns(
GroupBy(
Commitments,
"CommitmentItem",
"ByName"
),
"Count",
CountRows(ThisRecord.ByName)
)
This is the on select
Set(varComit, ThisItem); Set(UserRecordResult, LookUp(Agreements,Title=varComit.FK_Agmt_Cmit.Value)); UpdateContext({cmitSource: true});
Concurrent(
Set(varlhdr, First(Filter(LineHeaders, FK_Cmit_Lhdr.Value=varComit.Title))),
ClearCollect(collhdrs, Filter(LineHeaders, FK_Cmit_Lhdr.Value=varComit.Title)),
ClearCollect(collhdrsC, Filter(LineHeaders, FK_Cmit_Lhdr.Value=varComit.Title)),
ClearCollect(colfyrs, Filter(FiscalYearDetails, FK_Agmt_Fyds.Value=UserRecordResult.Title)),
ClearCollect(colfyrsC, Filter(FiscalYearDetails, FK_Agmt_Fyds.Value=UserRecordResult.Title)),
ClearCollect(fyex, Filter(Fydextended, FK2_Cmit_ID=varComit.ID));
);
.... Now if I try to change the filter of the nested gallery, varComit is set to error and the whole app turns RED. If I try to undo set it back, it doesn't fix the issues. Nor does restoring an earlier version. The only way I've been able to fix it is rename the variable through out the whole app which is a HUGE pain. What's the issue and how can I avoid this problem.
After trying to add a filter to nested gallery
Filter on nested gallery before:
Filter(Commitments, 'Commitment Item'=ThisItem.CommitmentItem)
Tried to change it to:
Filter(Commitments, 'Commitment Item'=ThisItem.CommitmentItem, Awardee = "John")
Let me know if you need anymore detail from the app. Thanks.
Solved! Go to Solution.
So i figure out that if I
1. Rename the varCmit variable throughout the app, then
2. Filter at the parent gallery level, then no issues.
Also, if there isn't a nested gallery:
1. Before making changes to the Items:
- comment out the onselect so it doesn't affect the variable
2. make the changes and confirm they are compatible with the variable.
3. Once it's good, go to onselect and uncomment the formula
Again, no issues.
So i figure out that if I
1. Rename the varCmit variable throughout the app, then
2. Filter at the parent gallery level, then no issues.
Also, if there isn't a nested gallery:
1. Before making changes to the Items:
- comment out the onselect so it doesn't affect the variable
2. make the changes and confirm they are compatible with the variable.
3. Once it's good, go to onselect and uncomment the formula
Again, no issues.
User | Count |
---|---|
251 | |
102 | |
94 | |
48 | |
37 |