cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Single line of text : can I add multiple values

Hi,

I filter the gallery view according to the user's login.

For example, on this screen the connected user only sees that user

 

vandrisse.png

For this I simply added my mail in the column Affectation and I created a filter of this type on the gallery

affectation.png

The filter is Filter(base;Affectation=varuser.Email) 

varuser is equal to user(). I use the variable to avoid the delegation warning.

 

However, many users need to see this value in gallery but I don't know how to add a second email address in the affectation column.

I have thinking to use a person column in sharepoint but this type of column is not delegable.

 

Do you have a tips ?

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

@ALP1 ,'

How many email addresses do you need to add?

You could put them all in separated by something like a comma, and then use

Filter(
   base;
   varuser.Email in Affectation
)

but you will have Delegation issues with this filter. Is this what you are trying to do? Also how many records are there in your list?

 

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.

View solution in original post

4 REPLIES 4
Highlighted
Super User III
Super User III

@ALP1 ,'

How many email addresses do you need to add?

You could put them all in separated by something like a comma, and then use

Filter(
   base;
   varuser.Email in Affectation
)

but you will have Delegation issues with this filter. Is this what you are trying to do? Also how many records are there in your list?

 

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.

View solution in original post

Highlighted

thank you @WarrenBelz 

 

The owner of the apps need to see the 7 000 records in the galery. 😞

I need to add 2/3 email in column affectation. 

 

email.png

 

 

Highlighted

@ALP1 ,

The in Filter will not function on 7,000 records due to Delegation restraints. I have done a blog on Delegation - have a look at the "big collection" reference as it may be a path for you.

 

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.

Highlighted

I had my customer yesterday and he is not worried about the delegation issue. 

So i can use the formula. I didn't knew about the in operator.

You are my hero of the day @WarrenBelz 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (10,859)