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
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:
Titil_Lookup (lookup type from sp list 1)
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
Hope this could be helpful.