@Dongle12 ,
If your SharePoint list has a Yes/No field (either a Text field with Yes/No in it, or a Yes/No column type), you can simply apply a Filter function in the Items property to exclude any record where the Yes/No field = No.
If you have a Gallery for example, you can apply the below to the Items property:
If the Yes/No field is a Single Line Text field in SharePoint:
Filter(
'Your Data',
'Yes or No Column' = Dropdown1.Selected.Value
)
If the Yes/No field is a Yes/No type field in SharePoint:
Filter(
'Your Data',
Dropdown1.Selected.Value = "No" || 'Yes No Column',
Dropdown1.Selected.Value = "Yes" || !'Yes No Column'
)
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
Imran-Ami Khan
