Answered

Filter not working in gallery when using index and split function

(0) Share

Report

Posted on by Raizo

This is odd and I don't know enough about why my filter would cause an error when I am pulling out just the name from the people picker value in Sharepoint. This is in reference to the question answer here.

Solved: Re: How to separate out just first and last name t... - Power Platform Community (microsoft.com)

But as you can see from the screenshots below I am using a string function to capture just the first and last name from a people picker field in SharePoint. That part works great. But when I try to apply a filter on my gallery I get an "index" error. Also see attachment below. Thoughts?

screenshot filter.png screenshot no filter.png

Categories:

General Questions

All responses (4)

Answers (1)

Raizo 66 on at

Like (0)

Report

Re: Filter not working in gallery when using index and split function

Thanks Warren! Yup! That did it .
Verified answer

WarrenBelz 147,870 Most Valuable Professional on at

Like (0)

Report

Re: Filter not working in gallery when using index and split function

@Raizo ,

A bracket after If( may assist here
Raizo 66 on at

Like (0)

Report

Re: Filter not working in gallery when using index and split function

THanks
Thanks for the quick response Warren. But now I am getting the error below....
WarrenBelz 147,870 Most Valuable Professional on at

Like (0)

Report
Re: Filter not working in gallery when using index and split function

Hi @Raizo ,

Just adding to the previous code I supplied - test to see if there is something in the field

If( Len(ThisItem.Facilitator.DisplayName) > 0, With( { _Data: Split( ThisItem.Facilitator.DisplayName, "," ) }, Index( Split( Index( _Data, 2 ).Value, " " ).Value, 2 ).Value & " " & First(_Data).Value ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps