I needed to remove all values by trimming then do the check like so:

If(!IsBlank(Trim(TextInput5_1.Text)), Patch(BookingTest,
{ Title: title, EventDate: TextInput5_1.Text });

Just time to concat the rest of the values now...

You need to define that it is the selected value from the dropdown.

So provided that the Q1 is in a datacard it would look like this for the default items where you want to have the text:

If(DataCardValue1.Selected.Value = "Q2", "No", "")

Hope it helps :)

Use IsBlank and Trim to check for any empty or whitespace strings.

IsBlank(Trim(Column2))

Trim will remove any whitespace and IsBlank will return a true/false if the string is empty or not after the trim.

IsBlank

Trim

UPDATE: Check only for IsBlank where Column2 is evaluated, the way you wrote it it's checking if Column2 = bool which will have a type mismatch since it's checking a string vs a bool, change to this:

ClearCollect(Test,LookUp(Table1,Column1=DataCardValue6.Text && IsBlank(Trim(Column2))))