Stuck on Office365Groups.ListGroups and filter

(0) Share

Report

Posted on by stefansc

Hi,

I'm getting stuck on using the Office365Groups.ListGroups connector applying a filter.

I have a gallery where I want to filter groups by a value entered into a text input.

When trying to set the items of the gallery to

Office365Groups.ListGroups({'$filter': TextInput3.Text}).value

I get an error "Invalid filter clause".
Unfortunately I did not find any examples on how to use the filter within this connector.
Any idea would be appreciated.

PS: Using the Graph API is no option

Regards

Stefan

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (0)

Report

I also had problems figguring out how to write that so I ended up just doing a ForAll() and then i could do a simple if statement inside of that. It's not perfect, so somebody else probably has a better answer 😃

Was this reply helpful? Yes No
GeoHris 47 on at

Like (2)

Report
Hi @stefansc,

I had the same issue and was unable to resolve it or to find any additional information.

What I did in my case, I have used Search in my items formula:
Search(Office365Groups.ListGroups().value, TextInput3.Text, "description")

This way I have been able to filter the gallery based on the text input.

Hope this helps 🙂

Was this reply helpful? Yes No
stefansc 89 on at

Like (0)

Report

Hi @GeoHris ,

this works but as Office365Groups.ListGroups() only returns 100 records it doesn't fit if you have hundred of groups.

Was this reply helpful? Yes No
Verified answer

GeoHris 47 on at

Like (4)

Report
Hi @stefansc,

The only thing that I managed to do and make it work, is the following:

Note, that when the text input is empty, I am receiving an error message that the query is not correct, but when I enter some text in the input, it is filtering correctly the gallery

The filter formula which is expected should be in OData style:

Office365Groups.ListGroups({'$filter': "startswith(displayName," & "'" & TextInput4.Text & "'" & ")"}).value

When I apply this in the items property, it is properly filtering the gallery:

2 people found this reply helpful.

Was this reply helpful? Yes No
stefansc 89 on at

Like (1)

Report

Hi @GeoHris ,

you made my day. This is exactly what I'm looking for.
Regarding the empty search field I can manage it only search for the groups when the text input is not empty.
Again, thanks a lot, you're genius.
Regards

Stefan

Was this reply helpful? Yes No
daniel_garcia 10 on at

Like (1)

Report
If you want an exact match (avoiding the starts with) you can do this:

Office365Groups.ListGroups({'$filter': "DisplayName eq '" & TextInput4.Text & "'"}).value

2 people found this reply helpful.

Was this reply helpful? Yes No
charan270 18 on at

Like (0)

Report
Search(Office365Groups.ListGroups().value, TextInput3.Text, "description")

This doesn't work. ListGroups doesn't return all the groups in the tenant. I was trying this option. The only options left are startsWith and EndsWith

Was this reply helpful? Yes No