Label Won't Show Filtered Result

[hsfournier]

I'm pretty sure the issue I am having is because my Session column, in Sharepoint is set as a number. But I have tried a ton of things and I can get the information to show. Here is my code in the Text property of my label. 

If(
!IsEmpty(cmbAttendees.SearchText),
$"Sessions Attended " & Concat(
Filter(
colRWAR,
cmbAttendees.Selected.Result in 'Applicant Name'
). Session,
", "
),
""
)

This is what I get

As you can see the commas for the 3 sessions attended are there, but not the numbers of the session.

Any help would be appreciated.

Heidi

[RandyHayes]

@hsfournier 

IsEmpty is used to determine the state of a record. 

What you want is the IsBlank function.

Also, your syntax is a bit off on the Concat function.  And, one other thing, the use of the $ is not relevant in your formula because you are not using inline information (i.e. there are no { } designations).

Please consider changing your Formula to the following:

If(!IsBlank(cmbAttendees.SearchText),
    "Sessions Attended " & 
      Concat(Filter(colRWAR, cmbAttendees.Selected.Result in 'Applicant Name'), Session, ", ")
)

I hope this is helpful for you.

[SudeepGhatakNZ]

Are you able to investigate

Filter(
colRWAR,
cmbAttendees.Selected.Result in 'Applicant Name'
)

in the designer session like this?

That should tell you where you are going wrong

[hsfournier]

Sorry for the late reply, I was out of town. When I use the code you suggested I get an error

When I select just the Filter(colRWAR, cmbAttendees.Selected.Result in 'Applicant Name').Session, I can see the results.

in the designer, but nothing shows in the label.

So I am still stumped. 

[hsfournier · Accepted solution]

Yay! Got it to work:

If(
!IsEmpty(cmbAttendees.SearchText),
"Session(s) Attended: " & Concat(
Filter(
colRWAR,
cmbAttendees.Selected.Result in 'Applicant Name'
). Session,
Text(Session),
", "
)
)

[RandyHayes]

@hsfournier 

Your formula still is incorrect!

IsEmpty on a text value is not going to give you an accurate result.

The formula should be:

If(!IsBlank(cmbAttendees.SearchText),
    "Sessions Attended " & 
      Concat(Filter(colRWAR, cmbAttendees.Selected.Result in 'Applicant Name'), Text(Session), ", ")
)

The error you had before was because I was not aware that your Session column was numeric.

[hsfournier]

Hi Randy,

Thanks for the feedback, I finally got it working by changing the cmbAttendees from cmbAttendees.SearchText (which I think was why the isEmpty was working) to cmbAttendees.Selected.Result.

If(!IsBlank(cmbAttendees.Selected.Result) ,
"<b>Signed Up For Session(s) Number: " & Concat(Filter(colRWAR,cmbAttendees.Selected.Result in 'Applicant Name'), Text(Session), ", "),
""
)