Unanswered

Power Pages Portal with authenticated access from multiple tenants (Entra ID & Micrsoft ID only)

(1) Share

Report

Posted on by MJB_PT

Hi,

I'm trying to build a simple Power Pages Portal that interacts with Authenticated Users from multiple tenants trough Entra ID and also Microsoft ID.
All users authenticated should only see see and edit all the fields in a Sharepoint List of the tenant where the Power Pages is and where:
- their authentication account e-mail is present in the Sharepoint field/column "Email"
- they can only see/edit their line and all of the lines where Sharepoint field/Column "AAAA" & "BBBB" values are equal to the values of their line.

I've configure Power Pages to allow only Authenticated Users access. Also that ID Providers were only ENTRA ID and Microsoft ID.
Permissions access is to tables, pages... also (supposedly...) defined.

I've successfully created the link trough a virtual table in Dataverse and explored a number of solutions to filter a view of the table due to the limitations of a virtual table, some using a flow to get "AAAA" & "BBBB" values corresponding to the authentication email as session variables from the Virtual table to input it.

However, I cannot populate any data to get the e-mail of the authenticated users online (tried multiple methods to get i also with help of liquid, flows, etc.). I see them authenticated, they are registered in the Power pages Active contact list with their email visible, but I can't "read" the authenticated User e-mail active in the session.

Any one can point me in the right direction to troubleshoot this?

PS For context, I'm not a Dev, only a Power User...

Categories:

Design & build

I have the same question (0)

All responses (2)

Answers (0)

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (0)

Report
Pls check the following:

Retrieve the authenticated user’s email using Liquid in Power Pages.

Use Power Automate to retrieve user-specific data (such as fields AAAA and BBBB) and set it as session variables.

Apply permissions and filters on the SharePoint list view based on session variables and user data.

Verify Dataverse contact mappings and permissions for secure access.

Test and debug to ensure the configuration works for each authenticated user.

let me know if you need more details.

thanks

Was this reply helpful? Yes No
MJB_PT 25 on at

Like (0)

Report

@SaiRT14,

thanks for the input.

I don't know why I cannot reply to your answer (no button to reply on it) so I'll leave here as a reply to my own.

I've done all that before the post and reviewed all the steps extensively. Sorry for not clarifying it well.

At the very end of day of this post I've found the culprit but didn't had yet the time do post the solution.

Code in Liquid was reading the wrong parameter of authenticated user...
All the info/examples I've found on it referred {{ user.email }} as the parameter to get. However, it should be {{ user.emailaddress1 }}.

Now it works well with ENTRA ID authentication and I will proceed during the present day to verify if next steps for filtering the list are all OK.

I will need also to use Microsoft ID authentication. Don't know if the field is also {{ user.emailaddress1 }} or if I need to check with liquid code somehow for its existence.

Thanks again for your reply.

Was this reply helpful? Yes No