News and Announcements icon

Power Platform CommunityForums Power Apps - GCC, GCCH, DoD - Federal App Maker... Model-Driven App Form ...

Power Apps - GCC, GCCH, DoD - Federal App Maker...

Unanswered

Model-Driven App Form Not Pulling Correct Active Directory Column

(0) Share

Report

Report

Posted on by danducati

16

I am new here & a new "developer."

My submission form for my main Dataverse table asks the submitter for the name of their direct supervisor. That field is a look up to our Microsoft Entra ID table (formerly the AAD/Active Directory). The Display Name (Employee Name) is the primary column & it returns that display name perfectly!
The next field in the submission form is also a look up to the same MS Entra ID table to get the direct supervisor's email address. However, it is pulling from the primary Display Name too, not the email column. My GCC version does not provide a visible way to reassign that field to the email column. Screenshots are attached & below.
Any ideas? Many thanks!!

Model-driven App ...

All responses Img

All responses (3)

Answers Img

Answers (0)

jwillisrosemsft Microsoft Employee on at

Like (0)

Report

Re: Model-Driven App Form Not Pulling Correct Active Directory Column

No, this is for GCC, GCC High and DoD related questions/issues. I just think your issue isn't unique to the US Gov clouds, hence you might find better answers faster in the regular forum.
danducati 16 on at

Like (0)

Report

Re: Model-Driven App Form Not Pulling Correct Active Directory Column

I saw the GCC reference (which we are on in my state) but didn't realize it was just for DoD.

Thanks for the reply!
jwillisrosemsft Microsoft Employee on at

Like (0)

Report

Re: Model-Driven App Form Not Pulling Correct Active Directory Column

Hey Dan,

First, welcome! Glad to have you here as a new maker.

Second, if your issue isn't related directly to GCC/High/DoD, I would recommend using the regular maker's forum for questions. You'll get faster response from the wider community.

For your issue, you don't need two lookup fields. I would first, try creating a calculated field and use the first lookup to populate the calculated (email) field. If for some reason that doesn't work, you can leverage JS to populate a text field or a flow (Power Automate). The latter will not populate in real time though, so the UX may not meet your needs.

But again, try the regular forum and you might get other options.

Helpful resources

News and Announcements

Upwork and Microsoft Power Platform Partnership

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans