cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Get Related Person or Group Field Data

I would like to get a person or group field data from SharePoint list according to combo boxes change event. Below is the scenario.

I have two SharePoint definition list and the main data list. Report Subject list gets the reference from Report Type list and I have two combo boxes which feed on those lists. When I changed those combo boxes, it should search the Report Type list with those two parameters. Then the query will get the AuthorizedPersons field value/s to the person type combo box from the Report Type list. But the data not getting. You can find the form visualization and the query that I used.

1- LookUp(Filter('Rapor Konusu',drpReportType.Selected.Value in Title),drpReportSubject.Selected.Value in DocumentType.Value,AuthorizedPersons)

2- Filter('Rapor Konusu',drpReportType.Selected.Value in Title && drpReportSubject.Selected.Value in DocumentType.Value).AuthorizedPersons

 

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Get Related Person or Group Field Data

Hi @Erdi ,

 

Do you want the Person type Combobox is based on another combobox which items is based from other SP list?

I think you can try the following workaround, I test as next:

DataSource:

Person(Person type)

20190315combobox1sp1.PNG

Titil_Lookup (lookup type from sp list 1)

20190315combosp2.PNG

 

App Test:

Add one button and Button1.OnSelect:ClearCollect(test1,'20190315person and group');ClearCollect(test2,AddColumns(test1,"PersonName",Person.DisplayName))

DataCardValue3.Items:Filter(test2,Title = DataCardValue2.Selected.Value).PersonName

20190315comboboxapptest.PNG

 

Result Test:

20190315comboboxresultgif.gif

 

Hope this could be helpful.

 

Best Regards.

Yumia

Highlighted
Anonymous
Not applicable

Re: Get Related Person or Group Field Data

Thanks for posting in the community @Erdi - can you review the above reply and update the thread if it was helpful?

 

Thank you,

 

@Anonymous 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (4,247)