Answered

Specify DEFAULT using department information in OFFICE365USER

(0) Share

Report

Posted on by Bingqiling

321

DB is SHAREEPOINT. There is a column in which the data type IT_MANAGER is a user or group.
And in FormMode.New's FORM, I want to put the word "IT" in the name of the department in the organization's OFFICE365USER as DEFAULT.
How should I do it?

If(
 Form1_2.Mode = FormMode.New, 
 {
 Claims: "i:0#.f|membership|" & Office365사용자.UserProfileV2(Filter( Office365사용자.SearchUserV2({isSearchTermRequired: false}).value, "IT" in Office365사용자.UserProfileV2().department)).Mail ,
 Department: "IT운영",
 DisplayName: "",
 Email: "",
 JobTitle: "",
 Picture: ""
 }
)

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Bingqiling 321 on at

Like (0)

Report
Copy link

Link copied!
If( Form1_2.Mode = FormMode.New, { Claims: "i:0#.f|membership|" & First(Office365사용자.SearchUser({searchTerm:"IT"})).Department , Department: "IT운영", DisplayName: "", Email: "", JobTitle: "", Picture: "" } )

No error occurs when this code is executed. But the price is empty.

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

Like (1)

Report
Copy link

Link copied!
Hi , @Bingqiling
You can try to use this code :

{ Claims: "i:0#.f|membership|" & First(Office365Users.SearchUserV2({searchTerm:"IT"}).value).Mail , Department: "IT운영", DisplayName: First(Office365Users.SearchUserV2({searchTerm:"Aniya"}).value).DisplayName, Email: First(Office365Users.SearchUserV2({searchTerm:"IT"}).value).Mail , JobTitle: "", Picture: "" }

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Bingqiling 321 on at

Like (0)

Report
Copy link

Link copied!

hi @v-yueyun-msft
An error has occurred.
error 1:
'Search UserV2' is an unknown function or
unsupported function in namespace 'Office365Users'.
location
error 2:
Function "First" has some invalid arguments.

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

Like (1)

Report
Copy link

Link copied!
Hi , @Bingqiling
You may try to use your language function in your side :
Office365사용자.SearchUser()

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Bingqiling 321 on at

Like (0)

Report
Copy link

Link copied!

hi @v-yueyun-msft

My mistake. Thank you.
The error is gone
But there's still no value

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

Like (1)

Report
Copy link

Link copied!

Hi , @Bingqiling
Dose your Form is The FormMode.New, it works in my side :
Or you can use the NewForm(FormName) to test:
And you can check if your code return value:

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Bingqiling 321 on at

Like (0)

Report
Copy link

Link copied!

hi @v-yueyun-msft
({sarchTerm: "Aniya" in "Aniya"} seems to be email information, but it will be successful if you find it by the name or email of that employee.
The method of finding using human name or e-mail information should be excluded.
I need to find it under the department name ({sarchTerm: "IT Operations").

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi , @Bingqiling
Thanks for your quick response!Do you mean you want to filter the Department field?

You can try to use this code to filter the Department field:

First( Filter( Office365Users.SearchUserV2({isSearchTermRequired: false}).value , Department ="IT" ) ).Mail
First( Filter( Office365Users.SearchUserV2({isSearchTermRequired: false}).value ,"IT" in Department ) ).Mail

{ Claims: "i:0#.f|membership|" &First( Filter( Office365사용자.SearchUserV2({isSearchTermRequired: false}).value ,"IT" in Department ) ).Mail , Department: "IT운영", DisplayName: First( Filter( Office365사용자.SearchUserV2({isSearchTermRequired: false}).value ,"IT" in Department ) ).DisplayName, Email: First( Filter( Office365사용자.SearchUserV2({isSearchTermRequired: false}).value ,"IT" in Department ) ).Mail , JobTitle: "", Picture: "" }

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No