Answered

Invalid argument type (table). Expecting a text value instead.

(0) Share

Report

Posted on by Incident-Manage

I am having trouble trying to filter a Power Apps Gallery based on a combo box. The gallery pulls from a data set that has a column labeled Hospital(s) in use and the combo box pulls from a list that has those same hospitals. Below is the code I tried however I am getting an error Invalid Argument Type (Table). Expecting a text value instead.

Filter(
 'Application List',
 If(
 IsBlank(ComboBox1.Selected.Title),
 true,
 ComboBox1.Selected.Title in Split('Application List'.'Hospital(s) in use', ";")
 )
)

My main gallery is called Application List and the List that the combo box pulls from is called Hospitals, and I am trying to compare the selected value(s) from the combo box with the value in the column on my sharepoint list called Hospital(s) in use which is a multi-select column.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Filter( 'Application List', IsBlank(ComboBox1.Selected.Title) || ComboBox1.Selected.Title in 'Hospital(s) in use' )
Incident-Manage 76 on at

Like
a
(1)

Report
Copy link

Link copied!

@iAm_ManCat that works and loads the data but when I select an option from the combo box the gallery is blank even though there is data that meets the selection.
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Ok, so to debug:

Take out the filter, make the gallery just point to 'Application List', then have two labels inside each row:

Label1:

ComboBox1.Selected.Title in ThisItem.'Hospital(s) in use'

Label2:

ComboBox1.Selected.Title & " in " & ThisItem. 'Hospital(s) in use' & " ?"

This should visually be able to show you which part of the condition is not being met
Incident-Manage 76 on at

Like
a
(0)

Report
Copy link

Link copied!

@iAm_ManCat I am trying to understand what you want. I understand that I should set the gallery to just look at application list but then after that am I adding a column to do the test?