o365 search to sharepoint list

(0) Share

Report

Posted on by LeeProcter

Hi,

I have an issue getting a o365 search list into a sharepoint list.

I've built a basic sharepoint list with two columns - Staff and Age (With an unused Title). The staff is a Person and the age is a number.

The powerapp literally shows both these columns in a gallery.

Rather than show the entire o365 users, i've filtered this down as thus, in Items:

Filter(Office365Users.SearchUser({searchTerm:DataCardValue2.SearchText}),"Staff" in OfficeLocation)

This brings back the correct users, based on the word 'Staff' in the OfficeLocation field.

When i use the 'SubmitForm', this does not write this selected info to the list.

I thought about using a patch function, but this does not work:

Patch('Patch', Defaults('Patch'), {Staff:DataCardValue2.Selected}) - where 'Patch' is the name of the SP list, and 'DataCardValue2 is the name of the Value of the Staff Datacard.

Has anyone got any ideas on how to get this to work?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@LeeProcter - it is difficult making sense of your post.

As I understand it, I think you have a Form, and in that Form you have a DataCard for the Staff people picker field. In the Items property of the Combo Box inside the DataCard, you have applied your filter expression.

You're now trying to save the selected staff member into your SharePoint list.

Is that correct?

Was this reply helpful? Yes No
LeeProcter 4 on at

Like (0)

Report
Copy link

Link copied!

Yes, thats correct.
Im not sure how to get the name selected into the sharepoint list

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@LeeProcter sorry I have been away. Do you still need help?

Was this reply helpful? Yes No
LeeProcter 4 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I solved this by:
For the whole data card, use the following in the ‘Update’ option: (change the Data card value to whatever yours is.)

{
  Claims:"i:0#.f|membership|" & DataCardValue2.Selected.DisplayName,
  Department:"",
  Email: DataCardValue2.Selected.Mail,
JobTitle:".",
  Picture:"."
}

Change Items of the DatacardValue to be: (change the Data card value to whatever yours is.)
Filter(Office365Users.SearchUser({searchTerm:DataCardValue2.SearchText,top:999}),"Students" in OfficeLocation)

Was this reply helpful? Yes No