the department is not pick up back end??? can anyone help. thank you - urgently need help

[bbsin]

HI

the patch back is working fine but the department column in SP Is empty; it's not pickup the data 

  Can anyone help?  Thank you

[JR-BejeweledOne]

It looks like there are some gaps in your Office365Users piece and you are missing a ")".  Start by fixing this:

Office365Users. UserProfile (User().Email.Department

Office365Users.UserProfile(User().Email).Department

[bbsin]

@JR-BejeweledOne 

Hi 

Patch('Activities Overall', Defaults('Activities Overall'),{ReservedBy:
{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & User().Email,
DisplayName:User().FullName,
Email:User().Email,
Department:Office365Users.UserProfile(User().Email).Department,
JobTitle:"",
Picture:""
},

I have edited the gap but it's still not picking up.  

Also Can I check how to add Salutation; First Name and Full Name in the syntax too?

Thank you

[JR-BejeweledOne]

EDITED

Drop a label on the screen and put this in the text property.   This will let you know if it's actually returning a value.  If it is returning a value, try setting a variable in your App OnStart to the department and use the variable in your patch statement.    This eliminates the extra overhead and lookup that you are doing by combining Office365Users.UserProfile with User.() and goes directly to the current users profile by using Office365Users.MyProfileV2()

Office365Users.MyProfileV2().Department

[JR-BejeweledOne · Accepted solution]

Here is another thing you can try.  Rather than using this:

Office365Users.UserProfile(User().Email).Department,

Try using this:   Office365Users.MyProfileV2().Department.    You are using the values for the current user with User.(), so eliminate that and the extra lookup it is doing by using MyProfileV2 instead.

[v-bofeng-msft]

Hi @bbsin :

The Department column is a Person or Group Column,you can not add a nonexistent person or group into this column.

What's more,the value of 'Office365Users.UserProfile(User().Email).Department' is a string,but you need to use a specific record or table in a specific format to update the Person or Group column.

I think this link will help you a lot:

Solved: Person column prepopulated patch error - Power Platform Community (microsoft.com)

Best Regards,

Bof

[bbsin]

Hi @JR-BejeweledOne 

Thank you.. I put a label and it's appears.  but it's just not patching back to the SP column?  Thanks

 try setting a variable in your App OnStart to the department and use the variable in your patch? - what do you mean??

Is it onstart - to add??? set(something??)   Thank you

Can I check how to add Salutation, Full Name and Surname into the syntax too so that it pick up into SP list columns?

Thanks

[bbsin]

hi @v-bofeng-msft 

Thanks for the link, I dont quite understand it.. the - 

ForAll(["test.user2@testing.com.au", "test.user1@testing.com.au"],

what do put in?

JR-B3ejeweledOne suggested 

Office365Users.MyProfileV2().department

 I tested with a label it does appear on the screen but it's just no picking into the SP column - I not sure why...

[JR-BejeweledOne]

You are already setting varUser to the user profile, which means that it contains all the profile information for the current user.  So for starters eliminate all the extra lookups you are doing by using the User.() or Office365 connector in your patch statement.   You already have all those values in varUser.   Modify your patch statement like this:  Make sure that varUser.department is typed varUser.department not varUser.Department.   Is department the only one that isn't being picked up?

Patch('Activities Overall', Defaults('Activities Overall'),{ReservedBy:
{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & varUser.email,
DisplayName: varuser.displayName,
Email: varUser.email,
Department: 
  If(!IsBlank(varUser.department), varUser.Department, ""),
JobTitle:"",
Picture:""
},

As far as salutations you can use  varUser.givenName and varUser.surname to get the first and last name. 

[bbsin]

Hi @JR-BejeweledOne 

Yes, it's only the department that is not picking back to SP list.

I try - if I put small cap d.. there's error but I selected Department from the PowerApps auto pick there's no error and it still not picking back into SP.

I tested with label on the canvas it does appear..   for both syntax on the label

not sure why it's not picking back to SP list.   Kindly help as the app needs to run on Friday.. .. Thanks.

Thank you

If I put as Cap D; there no error but it's not pick up in SP for the three columns data.  

I did a label test on the canvas it showing all but just not picking into SP List?

the surname and givenname are also not picking up?