Power Platform Community Forum Thread Details

Hello,

I have an Edit Form in my app that ties back to a SharePoint List. Two of the fields in my List are Supervisor Name and Employee Name. In my app I have the Items property set to filter the list down to only show the relevant information to the present user, rather than sorting through 500 names. This works in Power Apps, however, it doesn't write back to the SharePoint List correctly.

My formula for the Items property of Supervisor Name in my Edit Form is:

Office365Users.UserProfile(MyProfile.Id)

My formula for the Items property of Employee Name in my Edit Form is:

Office365Users.DirectReports(MyProfile.Id)

I do want to note that I have a variable named MyProfile that is set to the current user when they open the app, so that is what I am referencing to make my app dynamic. Also, my Edit form's DefaultMode is set to FormMode.New, so that is not an issue. I also am using SubmitForm to submit the form to my SharePoint List. I have tested this and other fields from my form write back to my SP List, but the names never transfer over.

Thank you in advance!

Categories:

Building Power Apps

What is your Columns data types in SharePoint for those columns? What is your Update property set to on the Cards for the Name / Sup Name?

If it's a person column you'll have to put this in for your Update:

{
 '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 Claims: "i:0#.f|membership|mdevaney@companyname.com",
 Department: "",
 DisplayName: "Matthew Devaney",
 Email: "mdevaney@companyname.com",
 JobTitle: "",
 Picture: ""
 }

But dynamically put in your Combo/Dropdown.Selected.Email etc. inside that to make it dynamic to write it back using string concatenation so like .

 Email: " & ControlName.Selected.Email & " ,

Reference here: PATCH A SharePoint Person Column In Power Apps - Matthew Devaney

If it's Text, update should be Control.Selected.Email or whatever in Update. Will all depends on data type.

Community site session details

Some data not writing back to SharePoint

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the August Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates