Filter ComboBox using another field?

[egallis]

Whenever you want to reset a control, just keep in mind that you just need to follow the same logic as the one I provided you for the ComboBox. Use a variable that you will set to TRUE then to FALSE (on the Submit button or on the OnVisible of the screen or on the OnSuccess of the form... just pick your choice) and put that variable on the Reset property of the control.

About your formula, what is the type of your field RequestStatus ?

[simms7400]

@egallis   Its is a choice field in SP as "ShortText".

Thank you!

[simms7400]

@egallis  Hi - I figured it out.

I needed ot use the actual column name.value - works like a charm!

SortByColumns(Filter(rdPartnerAssets,Title=PshipBrowseGallery.Selected.PartnershipId && RequestStatus.Value<>"Remove",StartsWith(Title, DataCardValue73.Text)), "Associated_Alias")

Thank you so much for all of your help!

[egallis]

Glad everything works fine !