microsoft / coe-starter-kit

Other
747 stars 219 forks source link

[CoE Starter Kit - BUG] Redo Portals flow with their new architecture #8038

Open BenUnlox opened 5 months ago

BenUnlox commented 5 months ago

Does this bug already exist in our backlog?

Describe the issue

Power Pages created In Developer environments aren't inventoried - other Environment types are not impacted by this.

Expected Behavior

Developer Environments to be fully inventoried.

What solution are you experiencing the issue with?

Core

What solution version are you using?

4.29

What app or flow are you having the issue with?

?

What method are you using to get inventory and telemetry?

None

Steps To Reproduce

No response

Anything else?

No response

AB#2869

Jenefer-Monroe commented 5 months ago

Please find a target envt where you expect to see power pages inventoried but do not. Then can you please check these two things for me?

  1. System Admin SR? Are you listed with the System Admin SR in the envt?

  2. Envt Properties Please find the environment in the CoE inventory table, and add the columns shown so we can understand current state for these properties: image

BenUnlox commented 5 months ago

Thanks for getting back to me!

  1. Yes - the account has the SysAdmin SR assigned.
  2. Screenshot 2024-04-10 at 16 27 36 (Hidden the Environment Name but happy to provide privately if needed)
Jenefer-Monroe commented 5 months ago

Can you go find the flow, add displayname as a column to view, and find this envt? You will likely need to hit "All Runs" and "Show More" image

Once you find it click the timestamp to open the run and let me see what you see. image

BenUnlox commented 5 months ago

Screenshot 2024-04-11 at 10 35 59 Screenshot 2024-04-11 at 10 37 57

Full Body:

{ "error": { "code": "0x80060888", "message": "Resource not found for the segment 'adx_websites'." } }

Jenefer-Monroe commented 5 months ago

That is the expected behavior if there are no portals in the envt.

Can you please look to see if there are Websites listed for the envt? Here from a dev envt in our test tenant image

And then if there are Power Pages there, look in the tables to see if this table is present: image

BenUnlox commented 5 months ago

In the example Environment given there are 3 Power Pages that do appear in both the locations mentioned in the previosu response:

Screenshot 2024-04-11 at 13 59 54 Screenshot 2024-04-11 at 14 00 37

Jenefer-Monroe commented 5 months ago

It seems like these are in this table instead yes? image

BenUnlox commented 5 months ago

Ah apologies! The screenshot above were from the 'mspp_website' table, the 'adx_website' table doesn't exist in this Environment.

Screenshot 2024-04-12 at 09 41 45

When I've checked other Environments, I couldn't find any that were created after 2021 that have the 'adx_website' table. In case this Table is added when a Power Page is created, I've created a Power Page in both a Developer and Production Environment - but in both this table still isn't present. The 'mspp_website' table is present in all Environments. Do we know if the 'adx_website' table get deprecated/replaced with the 'mspp_website' table?

Jenefer-Monroe commented 5 months ago

Yes it looks like they have moved forward with a deprecation that I was unaware of. We will have to redo our Portals work with this. Thanks for raising! Putting as a feature to do. We did a little early exploration a while ago and from what I recall, we will be using the new Power Platform V2 connector for this and unfortunately its not available in all regions yet so we will have to wait for that as well.

miguelverweij commented 5 months ago

I wanted to raise a new Feature Request, but I found this thread fortunately. The current Sync flow runs over Power Pages that use the adx prefix (adx_websites). this prefix is used for the "classic" Power Pages. If we want to put the Power Page Site in a solution, we need to enable the Enhanced Data Model. This is a different data model and stores the Power Pages Site in a tabel called mspp_website. The result is that all Enhanced Data Model Power Pages Site are currently out of scope for the inventory flow. @Jenefer-Monroe can you tell why this has the blocked status?

Jenefer-Monroe commented 5 months ago

It requires the new Power Platform for Admins V2 connector and it is not yet rolled to all regions. There are other features in there related to the new PIM feature which have forced it to ship to everywhere soon. Fingers crossed on that.