Answered

Saving default manager back to SharePoint list is not working

(0) Share

Report

Posted on by Community Power Pla...

Hello awesome people! I'm trying to apply a Global Variable:

Set(VarUser, Office365Users.MyProfileV2());
Set(VarManager,Office365Users.ManagerV2(VarUser.userPrincipalName))

To my form called FormEdit with DefaultSelectedItems set to the following for that field where I'm trying to retrieve the Manager name of the user logged in. So when I click on creating a new form, the manager does populate correctly, but then when I submit the form (using a check mark icon with SubmitForm(FormEdit).

If(FormEdit.Mode = FormMode.New,
Filter(
Table(
{
'@aodata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
DisplayName: VarManager.displayName,
Claims: "i:0#.f|membership|" & VarManager.mail
}),
Not(IsBlank(DisplayName))),
Parent.Default)

Why is the Manager name not saving to the SharePoint list? Once SubmitForm executes, it just sets itself back to blank (nothing selected). But the rest of

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yutliu-msft on at

Like (1)

Report
Hi @Anonymous ,

Do you want to use current user's manager to update person field in your sharepoint list?

Could you tell me whether your person field allows multiple value?

I've made a similar test but not met the same problem like your description.

You could refer this:

set the app's OnStart:

Set(VarUser,Microsoft365Users.MyProfileV2()); Set(VarManager,Microsoft365Users.ManagerV2(VarUser.userPrincipalName))

//please notice that this connector has renamed to Microsoft365Users, not Office365Users any more.
1)if your person field not allows multiple value:

set the combo box's DefaultSelectedItems:

If(Form1.Mode = FormMode.New, Filter( Table( { '@aodata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", DisplayName: VarManager.displayName, Claims: "i:0#.f|membership|" & VarManager.mail }),Not(IsBlank(DisplayName))),Table(Parent.Default))

2)if your person field allows multiple value:

set the combo box's DefaultSelectedItems:

If(Form1.Mode = FormMode.New, Filter( Table( { '@aodata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", DisplayName: VarManager.displayName, Claims: "i:0#.f|membership|" & VarManager.mail }),Not(IsBlank(DisplayName))),Parent.Default)

My person fields both have been updated successfully.

Best regards,

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

Like (0)

Report

Thank you for the reply. I followed your instructions and connected to the new Microsoft 365 Users, and was able to pull user and manager successfully into a test label. However, the field that I'm trying to populate is still not filling with the Manager name. Is there another setting I'm missing on that field? Before it was defaulting but not saving, now it's not even defaulting.

Any suggestions?

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

Like (0)

Report

Please disregard the last note. I saved, closed, reopened and tried again, and it worked, so must have some cached info somewhere.
Thank you so much!!!!! I really appreciate your help, you're awesome!!!!

Was this reply helpful? Yes No