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
Kudo Collector
Kudo Collector

@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
Kudo Collector
Kudo Collector

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,994)