Hi and thanks for your reply, I didn't realize the images were fuzzy, I'll add more info here.
1. Important to note: The update property is nowhere to be found on the PinCategories datacard and the PinSelection datacard. I found that this was an issue, but wasn't sure how to resolve it.
2. Pin Categories points to a list called Recognition Pin Names and is a lookup column. PinSelection points to the same list and points to a text field called 'Categories test', but I have it displaying the field I needed by changing the field layout. This was the only way I could get it to work correctly.
3. I was able to get the PinSelection to Filter on PinCategories by adding the code below:
Filter('Recognition Pin Names', 'Categories Test' in cbxPinCategories.SelectedItems.Value)
I've tried all sorts of formulas for the OnSuccess of the form and OnSelect of cbx but nothing is even coming close to doing what I need it to do. Here are a few examples of what I've tried.
Collect(
Collection1,
SharePointForm1.Updates
);
Collect(
colPinCategories,
{'Pin Categories 2': colPinCategories.Categories}
)
Added to OnSelectCbxPinCatogory
Patch(
'Recognition Program Nomination Form',
Defaults('Recognition Program Nomination Form'),
{'Pin Category': cbxPinCategories.SelectedItems.Value}
)
Deleted onselect and added to onsuccess
Collect(
Collection1,
SharePointForm1.Updates);
Patch(
'Recognition Program Nomination Form',
Defaults('Recognition Program Nomination Form'),
{'Pin Category': cbxPinCategories.SelectedItems.Value}
)
Added
Collect(Collection1, {'Pin Category':cbxPinCategories.SelectedItems.Value})
Changed to:
ollect(Collection1, {'Pin Category':cbxPinCategories.SelectedItems })
Added to OnSuccess:
Collect(
Collection1,
SharePointForm1.Updates
);
Collect(
Collection1,
{'Pin Category': cbxPinCategories.SelectedItems.Value}
)
Collect(
Collection1,
SharePointForm1.Updates
);
Collect(
Collection1,
{'Pin Categories': cbxPinCategories.SelectedItems.Value}
)
Collect(
Collection1,
SharePointForm1.Updates
);
Collect(
Collection1,
{'Pin Categories 2': cbxPinCategories.SelectedItems.Value}
)
