microsoft / coe-starter-kit

Other
751 stars 221 forks source link

Apps are missing from inventory #8113

Closed iprasadraju closed 5 months ago

iprasadraju commented 6 months ago

Does this bug already exist in our backlog?

Describe the issue

Hello Team,

I wanted to bring to your attention that we have the CoE Starter Kit March 2024 version installed in our environment. However, I've observed that couple of apps seem to be missing from the "Power Platform Admin View". One of the missing apps was created just 6 days ago. I have verified that the flow "Admin | Sync Template v3 (Driver)" is running daily without encountering any issues.

Could you please assist me in determining which Dataverse table (Power Platform OOTB table) stores the Canvas App and MDA information?

Does the "PowerApp Apps" table refresh its entire dataset daily, or does it solely incorporate new changes made within the environment?

Expected Behavior

After every run PowerApp Apps table should have all the Canvas apps and MDA information

What solution are you experiencing the issue with?

Core

What solution version are you using?

March 2024

What app or flow are you having the issue with?

Admin - Sync Template v3

What method are you using to get inventory and telemetry?

Cloud flows

Steps To Reproduce

I was trying to delete the missing model driven app, I am facing issue (screenshot attached) MDA Delete Error

When I try to check the same MDAs using "Power Platform Admin View", I didn't found the entry. However in make.powerapps.com screen I am able to see the app

Anything else?

No response

AB#2952

Jenefer-Monroe commented 6 months ago

Hello the v3 version of the driver flow was deprecated as of the release you are on so I suspect something is broken in your install. Can you please share a screenshot like this so we can see what solutions you have installed in this environment? Be sure to show all records (all rows) and expand the indicated columns so that we can see full names image

iprasadraju commented 6 months ago

Apologies for the confusion. Instead of referring to v4 (Admin | Sync Template v4 (Driver)), I mistakenly mentioned v3. Could you kindly assist me in identifying the table name (Power Platform OOTB table) that stores the information for Canvas App and MDA?

CoE Solution List

Jenefer-Monroe commented 6 months ago

Those are stored in the PowerApps App table image

Jenefer-Monroe commented 6 months ago

After looking in that table, if you do not see the expected app, please follow these instructions

Find a repro

You will need to find a repro of this in your tenant to see what is going wrong.

  1. Find an environment in your tenant where you expect to see the object (ex this app missing, that chatbot missing, etc)

  2. Go to the Power Platform Admin view app and find that environment. Open the record, edit some field, and save Note you will want to change back so be aware of the change. image

  3. This will trigger all the object flows to run for that environment. Find the flow for your object of interest and open it to details page. Ex: if you are looking for missing canvas apps chose Admin | Sync Template v4 (Apps), if you are looking for missing Model Driven Apps chose Admin | Sync Template v4 (Model Driven Apps), etc image

  4. Click on the timestamp of run in progress (or the one that just finished) to see the run itself. image

  5. From here you can explore if there is a failure, or if a bad return set, etc. And let us know if you have questions

iprasadraju commented 6 months ago

In my scenario, the Model Driven App is absent. After adhering to your guidance, the workflow "Admin | Sync Template v4 (Model Driven Apps)" executed smoothly. This workflow pertains to the "appmodules" table.

While I can spot the "appmodules" table in the security role permissions list AppModule Table - SecurityRole

"appmodules" (Model-driven App) table is missing from the tables list.

AppModule Table

Jenefer-Monroe commented 6 months ago

Yes unfortunately its a hidden product table, so you can't view it in the UX.

girishuppal commented 6 months ago

Hello @iprasadraju

In case you want to view the list of entire model driven apps in your tenant see this video

https://youtu.be/uFwkanybCXI?list=PL5xdZrvu1OhUISeASn3Zi1gTWwlZRGfQT

You can write a simple power automate flow to view all of the apps in your tenant. Thanks

Jenefer-Monroe commented 6 months ago

You MDA inventory should be in the CoE tables as well. Please find a repro for us as described above and we can debug

iprasadraju commented 6 months ago

@girishuppal, Thanks for the link

@Jenefer-Monroe, MDA is not appearing in the CoE tables "PowerApps App" or "appmodules". However, I can confirm that the app is visible in the UX

Jenefer-Monroe commented 6 months ago

Are you saying that here:

the app is not returned for that envts run? image

If so, please be sure you are in the run for the correct envt, and then go check the SR of the identity running the flow in that envt.

iprasadraju commented 6 months ago

Yes, I'm referring to "List Envt MDAs". I've specifically created a new workflow to query the "appmodules" table. The missing Model-Driven App (MDA) did not exist in the first place.

Jenefer-Monroe commented 6 months ago

Did anything return? Any Model Driven Apps? Please go check the Security Role of the identity running the flow in the environment permissions.

iprasadraju commented 6 months ago

Indeed, "List Envt MDAs" returns the list of Model-Driven Apps (MDAs) excluding the missing app. I am executing the flow using the Power Platform admin account.

Jenefer-Monroe commented 6 months ago

Can you please go check the Security Role of the identity running the flow in the environment permissions? There are some changes happening that make it so you dont get added to envts as Sys Admin anymore by default.

iprasadraju commented 5 months ago

I have double-checked the flow identity, and it indeed has the "System Administrator" security role.

Jenefer-Monroe commented 5 months ago

OK so to summarize.

Is that accurate?

Jenefer-Monroe commented 5 months ago

closing out as no further action for starter kit team