
So I'm building a document request list generator; will populate a sharepoint list for clients to upload documents to the list for submission.
So I built one in my personal account and since I couldn't get the list to migrate over with relationships in tact; I decided to rebuild the relationships with IDs.
Below is a picture that shows the filter not being set and displaying all results from DocList Datasource.This shows the filter not being set by ComboBox; and displaying all Document Types
If(!IsBlank(ComboBox1), Filter('Doc_List-0', ComboBox1.Selected.ID in 'EngageType:ID'.Value), 'Doc_List-0')
Above is the Function I put on the ListBox; which works perfectly..
Now because of the migration problems I changed 1 thing, which is the ID is now the primary lookup column and title is filled for ease of tracking within the data source.
Now in my work environment; I do the EXACT same thing but data doesn't show when filter isn't set.
Screenshot:
And the function I applied to this listbox.
If(!IsBlank(EngageSelect), Filter('Doc-List-DB', EngageSelect.Selected.ID in 'EngageID'.Value), 'Doc-List-DB')
Now in my professional opinion, they are the EXACT same thing but the filter has to be applied for output in the listbox.
It's making me pull my hair out as it's honestly not a NEEDED feature but for general look and feel it kind of is...
Any type of direction would be super helpful, I literally have NO idea why it's not working unless it's because I switched the lookup columns; but I don't think that should be an issue unless I'm missing something.
Thanks.
Well I figured it out, just needed to set ComboBox.Selected in the isBlank function.