What columns got relation between Solutions and Apps Tables

[devvelegandla]

Does this question already exist in our backlog?

• I have checked and confirm this is a new question.

What is your question?

We are trying to cleanup large set of unused apps within the solutions. We are struggling to find the related information between the apps and solution tables. Could you please let us know if we can add a solution Name to the Power Apps Table?

Thanks,
Devendra

What solution are you experiencing the issue with?

Core

What solution version are you using?

4.43

What app or flow are you having the issue with?

No response

What method are you using to get inventory and telemetry?

Data Export

[Jenefer-Monroe]

Hello.
Retrieving the components of a solution is not very simple unfortunately. We use a table in each envt called solutioncomponents which is hidden and has some undocumented fields we use to find object types.
Honestly we kind of force tested this until it returned what we wanted.
You can play around though and see if you find something better / easier. If you do please let us know!

You can find this in the CLEANUP HELPER - Solution Objects flow (note in Feb it was still part of the Admin | Sync Template v4 (Solutions) flow)