Power's import csv(or excel) invitees in group

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I want to import external users (firstname lastname, email) as invitee in group from a CSV or Excel File.

I tried with AzureAD connector:

AzureAD.CreateUser(true;TextInput1.Text;TextInput1_1.Text;"23er45RE";TextInput1_1.Text);;
AzureAD.AddUserToGroup(GroupeID;TextInput1_1)

But It doesn't work.

Can you help?

Thank you

Patrick

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Patrick,

Could you please explain a bit for what you would like to achieve here?

When excuting the following command, have you seen any error messages?

"

AzureAD.CreateUser(true;TextInput1.Text;TextInput1_1.Text;"23er45RE";TextInput1_1.Text);;
AzureAD.AddUserToGroup(GroupeID;TextInput1_1)

"

Regards,

Michael
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Error:
Invalid argument type (Text). Expecting a Record value instead.

It seems to be on password parameter.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-micsh-msft any idea on the error type? how to put a record instead a text for password?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Why you are not using flow to do so ? like that :
ofc you can use excel instead of sharepoint
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

I don't use Sharepoint. I've a list of new contacts every month in CSV/ Excel file and I must import them, add them to differents groups and some other tasks.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes just replace the share point connector by an excel connector and that's working
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,

Sorry but the problem is not on Excel but on AzureAD connector. AzureAD don't "want" to create the external account due to an error on passowrd!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-micsh-msft haw can I create the "record" for password?