Obtain logged in user attributes

(0) Share

Report

Posted on by iwaldman

159

Hi forum,

I have a use case that requires the logged in user's time zone, locale (language/country), currency and email address.

I know that Portal Users are based on Dataverse Contact records and that Liquid has the user object.

Other than email address, do the other aforementioned attributes even exist in the context of Power Pages and if so how does one go about querying this information?

Thanks in advance!

Categories:

Customize & extend

I have the same question (0)

All responses (4)

Answers (1)

Sort by

oliver.rodrigues 9,455 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi, you should be able to access any attribute from the Contact record by using the User object. This includes country/language/custom attributes etc

Available Liquid objects - Power Apps | Microsoft Learn

Available Liquid objects - Power Apps | Microsoft Learn

Was this reply helpful? Yes No
iwaldman 159 on at

Like (0)

Report
Copy link

Link copied!
Thanks for the confirmation.

Do you know how to get the current user's time zone? I've tried the following:

var adx_timezone = `{{user.adx_timezone}}`; console.log(`adx_timezone = ${adx_timezone}`); // adx_timezone = 20 console.log(`browser timezone = ${Intl.DateTimeFormat().resolvedOptions().timeZone}`); // browser timezone = America/Chicago

Is there a way to convert "adx_timezone = 20" to its display name?

Was this reply helpful? Yes No
Verified answer

oliver.rodrigues 9,455 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@iwaldman the timezone comes from a table in Dataverse. Below fetch would bring the results based on the user timezone:

{% fetchxml timezoneDefinition %} <fetch mapping="logical"> <entity name="timezonedefinition" > <attribute name="userinterfacename"></attribute> <attribute name="standardname"></attribute> <filter type='and'> <condition attribute='timezonecode' operator='eq' value='{{ user.adx_timezone }}' /> </filter> </entity> </fetch> {% endfetchxml %} {% for timezone in timezoneDefinition.results.entities %} <div>User Interface Name: {{timezone.userinterfacename}}</div> <div>Standard Name: {{timezone.standardname}}</div> {% endfor %}

Don't forget to add Table Permissions to the timezonedefinition table

Not sure if this table is retrievable by WebAPI, it might be an option as well

Was this reply helpful? Yes No
iwaldman 159 on at

Like (1)

Report
Copy link

Link copied!
@OliverRodrigues Worked like a charm, thanks!
webapi.safeAjax({ type: 'GET', url: `/_api/timezonedefinitions?$select=standardname,timezonecode,userinterfacename&$filter=timezonecode eq ${'{{ user.adx_timezone }}'}`, contentType: 'application/json', success: function (data, textStatus, xhr) { var results = data; console.log(results); for (var i = 0; i < results.value.length; i++) { var result = results.value[i]; // Columns var timezonedefinitionid = result['timezonedefinitionid']; // Guid var standardname = result['standardname']; // Text var timezonecode = result['timezonecode']; // Whole Number var userinterfacename = result['userinterfacename']; // Text console.log({timezonedefinitionid, standardname, timezonecode, userinterfacename}); } }, error: function (xhr, textStatus, errorThrown) { console.log(xhr); }, });

Was this reply helpful? Yes No