cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AnthonyPhan
Kudo Kingpin
Kudo Kingpin

Find where a collection is referenced

Hi All,

 

I have a rather large powerapp with hundreds of objects. With in my app I have collection called "Collection1" which could be created or populated at numerous locations.

I have run into an issue where "Collection1" has been defined wrong somewhere withn my app which causes many of my galleries and buttons to show an error. 

I would like to find all instances of Collection1 so I can remove it. Is there a way to find everywhere where Location 1 have been referenced. This can currently be done with variables but I cannot see a way to do this with collections.
image.png

5 REPLIES 5
Mike8
Memorable Member
Memorable Member

Yes, that would be very helpful. If we could have for collections the functionality that exists for the variables.

v-xida-msft
Community Support
Community Support

Hi @AnthonyPhan,

 

Do you want to find where the "Collection1" have been referenced as that within Variables in your PowerApps app?

 

If you want to find where the Collection1 have been referenced as that within Variables in your PowerApps app, I afraid that there is no way to achieve your needs in PowerApps currently.

 

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DeeTronSEAM
Advocate V
Advocate V

@AnthonyPhan ,

 

If you didn't post your own idea, there is a similar here, if you haven't voted for it already..... 

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/How-do-I-find-where-a-Collection-is-created/idc...

 

But until the PowerApps team gives us that capability, an alternative "workaround" when you've reached your wits' end is to save the app locally (aka Save as to "This computer") as an .msapp file.  Then change the downloaded file's extension to .zip.  Next unzip the file.  Finally, using the power text editor of your choice (e.g. Notepad++, Visual Studio Code), search against all files in the unzipped folder's contents for the name of your MIA collection.

 

It's a bit esoteric to dig through the "compressed" JSON and junk in the search results, but with a bit of turning your head sideways and using Google Translate to go from geek-speak to the (human) language of your choice, you can zero in on where the collection shows up in your app.

 

I can't find the original post of the person who taught me this trick, but credit goes to him/her. Just trying to share the knowledge.

 

Here is a screenshot of me hunting down a collection I had replaced with a newer collection but couldn't locate to cull.  I.e. I'm using VS Code pointed at the folder that came from the unzipped .msapp file/archive to search for coll_AllQuestions.  And another showing the actual entry in PApps studio...

 

 

Hunting Collections and Formula Text with VS Code.png

 

 

 

 

 

.

..

... and now located in PApps....

Hunting Collections and Formula Text with VS Code pt2.png

 

 

@DeeTronSEAM  fantastic solution!  Saved me a mighty headache.  Thanks for sharing.

DeeTronSEAM
Advocate V
Advocate V

In addition to the app as .zip export and hunt method I describe above, I've just come across the "PowerAppps Review Tool" available here: https://github.com/microsoft/powerapps-tools#powerapps-review-tool 

 

It allows you to export an app as an MSApp file and see all your functions, and it highlights what formulas/properties have been changed from the PApps default values.  You can export the report as JSON or HTML.  This is easier than the export as .ZIP and extract method I described.

 

Do be aware that the tool can APPEAR to hang (e.g. Not Responding) when you open your MSAPP file.   I.e. it can take SEVERAL minutes for the tool to chew through the app and generate the report.

 

Here (attached) is an example screenshot of a report:

 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,157)