Updating an SP List from an Office365Users data source

[SteveRoach]

Hi Guys,

I've had a good trawl through similar questions but just can't seem to get this to work...

I would like to be able to pick a user from the Office365Users list and store the user details in a SharePoint List.

I have created a SharePoint List (Test People) with two columns:

• Title: Out of the box as-is
• Person:
  • Type: Person
  • Required: Yes

I can add records to this in SP and it happily lets me pick Users and add them.

I've gone on to create a Power App based on this list. I'm using the 'Start from data' method connecting to this List. When built, I add the Data Source; Office365Users.

The app consist of 3 screens, but the one I am interested in here is the EditScreen. To configure this:

• Navigate to Person_DataCard/DataCardValue
• Unlock to change properties.
• Change the Data/Items field to: Office365Users.SearchUser({searchTerm : "", top:999})

Now, I know that this will not bring back a full list for a large number of user but our user base is quite small and, anyway, one thing at a time...

When I test this app:

• I can successfully navigate to the Edit screen.
• I put some random stuff into the Title field.
• The down-arrow on the Person field successfully presents me with a list of my Users and, when I select one of these, the field is correctly populated.
• I click the [Tick] button to save the record and this reports no error.
• When I go to SharePoint to look at the content of the list:

I've tried a few of the suggestions on this forum but don't seem to be able to get any of them to work. Can anyone point me in the right direction?

Cheers

Steve

[Anonymous]

Hi capoaus75!  

Thank you so much for responding so quickly. 

I'm new to Power Apps and I tried to implement this coding but I'm definitely not understanding how to insert my relevant fields into your coding.  

The only connectors I have in my App are to Office365Users and my Sharepoint List ("Timesheets").

I tried to insert all 3 parts of your coding into the Update property of my DataCard ("Employees whose Timesheets are Grouped for Approval") in which a user can select names from a DropDown ComboBox (DataCardValue74) .  In the Items property of this combobox, I have a filter so that the user can only search for individuals with a specific email address:  Filter(Office365Users.SearchUser({searchTerm: DataCardValue74.SearchText}), "@_____.com" in Mail).   

From your comments I think I can follow the intent of what the coding does.  You first want to be able to collect all of the selected items and store it in a collection.  Is this a collection you're creating through the coding or should this refer to another sharepoint list?

I also noticed you have azure listed as a connector somewhere.  I'm assuming it's because azure is what Microsoft uses to house what is needed for Power Apps.  Also the 'Docs Approval' table in the Patch formula - I'm assuming this is where I should enter my Sharepoint list?  

If you can help narrow down where my issue is, I would really appreciate it.

Thanks for all your help already 🙂

[Anonymous]

Hi capoaus75,

I replied earlier and have been doing more research and I still haven't been able to make this work successfully.  I loosely understand what a collection is now.  Would you be able to send screenshots of where the 3 sections of coding is located?

[capoaus75]

Hi @Anonymous sorry for the late reply, but I have been affected by the flooding here in Australia and was without power for a week.
Anyway let me know if you still need help and I will send you more details ASAP. In the meanwhile if you want to have a look at this post it may help you Patch person/group field with multiple selection - Part 1 (capisani.com.au)