Filtering Collection Not Working

(0) Share

Report

Posted on by Nievechica24

Hello!

I have a collection that stores environments and a dataverse table that we update with the environments we want to display in our app. I was filtering the collection based on a filter in our dataverse table (see original code below). This has been working for over a year with absolutely no changes and then yesterday it stopped working. It does not show an error, it just shows blank instead of the environment name. The 'Environment Name' column is a single text field. It will work with another column called 'Environment ID' which is also a single text field. Not sure why it stopped working all of a sudden.

Filter(
colAllEnvironmentsFriendly,
FriendlyName in Filter(
'Environment Profile',
'Environment Type' = "DEV"
).'Environment Name'
)

Any help would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

abc 123 789 Moderator on at

Like (0)

Report
Copy link

Link copied!

These are just suggestions to help you debug.

First thing to check is that some pyschopath didn't modify any fiednames in the Table structures.

Next, break down your current code to a second collection. Ensure that it's being populated as you expect.

ClearCollect(colProfileDEV,

Filter(
'Environment Profile',
'Environment Type' = "DEV"
).'Environment Name'

)

Then, do the combo of collections to extract the data.

Filter(
colAllEnvironmentsFriendly,
FriendlyName in colProfileDEV.'Environment Name'
)

Was this reply helpful? Yes No
WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Nievechica24

Another suggestion - separate the filters
With( { _Names: Filter( 'Environment Profile', 'Environment Type' = "DEV" ).'Environment Name' }, Filter( colAllEnvironmentsFriendly, FriendlyName in _Names.'Environment Name' ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Nievechica24 20 on at

Like (0)

Report
Copy link

Link copied!

Thank you both for your responses. I tried both and neither worked. They do not error, it just does the same thing - blank entries. I tried switching the environment name for environment id and that works, but not showing the information that we want (showing id instead of the friendly name).

Was this reply helpful? Yes No
Nievechica24 20 on at

Like (0)

Report
Copy link

Link copied!

Also I am the only user with access to edit the app and I have made no changes since March of this year.

Was this reply helpful? Yes No
Nievechica24 20 on at

Like (0)

Report
Copy link

Link copied!

abc123,

It does create the collection correctly, but still shows blank when I try to filter the collection. I even tried using the schema name and nothing.

Was this reply helpful? Yes No