[CoE Starter Kit - BUG] Admin | Welcome Email v3 has failed for orphaned users

[annsarP]

Does this bug already exist in our backlog?

• I have checked and confirm this is a new bug.

Describe the issue

Hello, we discovered that Admin | Welcome Email v3 has failed for our service account. This service account appears as typical user in Maker table but has no apps, flows and no User Email, as a consequence flow is failing because "To" field is blank. Only one solution was created with this account. What might be the reason of missing User Email? User Principal Name field is storing e-mail address without any issues.

Expected Behavior

No response

What solution are you experiencing the issue with?

Core

What solution version are you using?

October 2023

What app or flow are you having the issue with?

Admin | Welcome Email v3

What method are you using to get inventory and telemetry?

None

Steps To Reproduce

No response

Anything else?

No response

AB#286

[Jenefer-Monroe]

Yes unfortunately that is a requirement of the identity running the kit, it must be email enabled. Please see What identity should I install the CoE Starter Kit with?

[annsarP]

Hi, our service account that we are running the kit with has User Email field filled. However, the value of this field is missing for other service accounts and for no-longer existing user accounts, is that because for these accounts email is not enabled (no access to Office 365 mailbox)?

[annsarP]

Hi I investigated a little more and one of the users from Makers table has no User Email as well but is active user, has licenses assigned and mailbox enabled. What might be the reason for missing User Email field? Is Maker table updated anyway? So for example if user's manager will change - will we see this change for this user in the Maker table after one of the syncs or Maker row is just being added and after that only resources created by this person are changing?

[Jenefer-Monroe]

There is a flow called CLEANUP - Admin | Sync Template v3 (Orphaned Makers) which runs each week and updates this type of information. Can you can go trigger it now to run and see if that fixes up these users?

[annsarP]

I ran it and unfortunately number of Makers without User Email is still 22. Can lack of apps, flows, solutions etc. be the reason?

[Jenefer-Monroe]

Go to the run of the flow, find one of your 22 users with missing email in the output of "List Makers"
Find that iteration of the loop and see what is returned for Get Maker, especially for these properties
"userisorphan"
"userissystem"
"userisserviceprinciple"

[annsarP]

None of these 22 users is contained in outputs from "List Makers" action 😄

[Jenefer-Monroe]

I'm a little confused now.
The flow in questions (Admin | Welcome Email v3) runs when a user is added to the Maker table but it appears they are not in the maker table.
Can you please restate what failure you are hitting right now?

[annsarP]

Sorry, my bad, we have so many Maker rows (over 1k) that it couldn't search for these users via CTRL+F in outputs. I pasted them into Notepad and I was able to find user there. Here are "Get Maker" properties for user (Service Account) that flow Welcome Email failed for (no UserEmail):

For the user (not Service Account) that has no UserEmail properties are following:

(So I think in this case userisorphan:true is the reason, correct?)

[Jenefer-Monroe]

Yes that does appear to be the case. If the user is orphaned when they get added to the Maker table then the send of the email will fail.
I've added a second catch here to exit early if the maker is orphaned (or service account which was there previously)

Thanks for posting!

[CoEStarterKitBot]

@annsarP This has been fixed in the latest release. Please install the latest version of the toolkit following the instructions for installing updates. Note that if you do not remove the unmanaged layers as described there you will not receive updates from us.