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
Solved! Go to 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),
", "
)
)
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.
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
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.
Yay! Got it to work:
If(
!IsEmpty(cmbAttendees.SearchText),
"Session(s) Attended: " & Concat(
Filter(
colRWAR,
cmbAttendees.Selected.Result in 'Applicant Name'
). Session,
Text(Session),
", "
)
)
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.
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), ", "),
""
)
User | Count |
---|---|
252 | |
106 | |
95 | |
50 | |
39 |