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