Answered

AzureAD Create User

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Experts 🙂

Maybe I try to be too clever, but here is my case.

I am developing a business app for my company with an employee register. My plan is that when I new employee starts, I will use the information already registered on the person to create a new user in Azure AD.

I found this AzureAd connector and used a gallery where I select the new employee to be created in Azure AD.

I quickly got stuck with the password part:
azureAD CreateUser.PNG

The passwordProfile allways complain about it need a record. I tried making a collection, a variable and plain "password", but nothing works.

Please advice, and thanks in advance for any feedback 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,

I have tested on my side, and it works well.
PasswordProfile needs to be record type, but “ recordPassword.Password” shown in the screenshot seems to be table type.
You can use {ColumnName1: value1, ColumnName2: value2,…} to create a record.
Please refer to following formula:
AzureAD.CreateUser(true;"Test Test";"Test Test", {password: First(recordPassword).Password} ,"test.test@test.no")
For more information of record, please review following document.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-tables#elements-of-a-table

Best regards,
Sik

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-siky-msft . Thanks for the push in right direction.

The solution that worked for me was to make a collection named _password with a column named password and then use First(_password)
AzureAD.CreateUser(true;inp_azureDispName.Text;inp_azureDispName.Text;First(_password);inp_azurePrinsipal.Text;{givenName:inp_azureFornavn;surname:inp_azureEtternavn;department:inp_azureAvdeling;jobTitle:drd_azureStilling.Selected.Navn})
It would not accept First(_Password).Password as it asked for the column password.

Now I get e feedback with a bad request:
I will search for a solution for this now. If you have any solutions for me, I appreciate, if not, thanks a lot for the help with the password.

Best regards
Tommy

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TurboTape ,

The error shows that your mailNickName is invaild, please check if there is sapce or other illegal characters in it.

Best Regards
Sik

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

There was a space yes. All good now, and it works perfectly 🙂

Thanks 🙂

Was this reply helpful? Yes No
Adi007 34 on at

Like
a
(0)

Report
Copy link

Link copied!

would you mind to show us how did you made this to work =)?

Was this reply helpful? Yes No
gaborszollosy 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello there!

Thanks for your answer! Can the password in your example be set permanent, not requiring the user to change it on the first sign in?

Thank you!

Was this reply helpful? Yes No