Answered

ParseJSON multiple users from SharePoint list to People Picker in PowerApps

(0) Share

Report

Posted on by NicolleAbrahams

Hello,

I am trying to use ParseJSON to get a SharePoint item, the SharePoint list has a column that can contain multiple people. I am having trouble bringing that into PowerApps.

Below is my flow,

And my OnStart property where the flow runs is,

Set(varTasks,'BPA-DC-TaskInformationRetrieve'.Run(varParam).taskresult);
Collect(
colTaskResult,
ForAll(
Table(ParseJSON(varTasks)),
{
ID: Value(Value.ID),
Title: Text(Value.Title),
DocumentNumber: Text(Value.DocumentNumber),
Division: Text(Value.Division),
PracticeArea: Text(Value.PracticeArea),
Area: Text(Value.Area),
DocumentType: Text(Value.DocumentType),
Revision: Text(Value.Revision),
DocumentController: Text(Value.DocumentController),
ProcessOwner: Text(Value.ProcessOwner),
Approvers: Text(Value.Approvers),
FileNamewithExt: Text(Value.FileNamewithExt),
RequestType: Text(Value.RequestType),
RequestDescription: Text(Value.RequestDescription),
Comments: Text(Value.Comments)
}
)
)

Does anyone have any idea how to get that Approvers object to a form where I can add the values to a ComboBox People Picker to search the email addresses.

TIA

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-jefferni on at

Like (1)

Report
Hi @NicolleAbrahams ,

You should be able to get the table Approvers from ParseJSON outputs into collection. I assume the array of Approvers in the flow only includes the Claims column, the formula would be:

Set(varTasks,'BPA-DC-TaskInformationRetrieve'.Run(varParam).taskresult); Collect( colTaskResult, ForAll( Table(ParseJSON(varTasks)), { ID: Value(Value.ID), Title: Text(Value.Title), DocumentNumber: Text(Value.DocumentNumber), Division: Text(Value.Division), PracticeArea: Text(Value.PracticeArea), Area: Text(Value.Area), DocumentType: Text(Value.DocumentType), Revision: Text(Value.Revision), DocumentController: Text(Value.DocumentController), ProcessOwner: Text(Value.ProcessOwner), Approvers: ForAll(Table(Value.Approvers),{Claims:Text(ThisRecord.Value.Claims)}), FileNamewithExt: Text(Value.FileNamewithExt), RequestType: Text(Value.RequestType), RequestDescription: Text(Value.RequestDescription), Comments: Text(Value.Comments) } ) )

Best regards,

Was this reply helpful? Yes No
NicolleAbrahams 75 on at

Like (0)

Report

That worked great to get the Approvers value from Power Automate. I am now having trouble displaying those multiple values in a People Picker. I have the following on the DefaultSelectedItems, any idea why this is not working?

ForAll(First(colTaskResult).Approvers, ThisRecord.Claims)

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (1)

Report
Hi @NicolleAbrahams ,

Since you only have Claims values, in Combo box it cannot find the corresponding person from the person column.

Actually, based on my test, the array variable is not needed in the flow. You can use multi-select person column in the Select action directly.

Then in your App, get required columns (DisplayName, Email, Department and JobTitle) value:

Set(varTasks,'BPA-DC-TaskInformationRetrieve'.Run(varParam).taskresult); Collect( colTaskResult, ForAll( Table(ParseJSON(varTasks)), { ID: Value(Value.ID), Title: Text(Value.Title), DocumentNumber: Text(Value.DocumentNumber), Division: Text(Value.Division), PracticeArea: Text(Value.PracticeArea), Area: Text(Value.Area), DocumentType: Text(Value.DocumentType), Revision: Text(Value.Revision), DocumentController: Text(Value.DocumentController), ProcessOwner: Text(Value.ProcessOwner), Approvers: ForAll(Table(Value.Approvers),{Claims:Text(ThisRecord.Value.Claims), DisplayName:Text(ThisRecord.Value.DisplayName),Email:Text(ThisRecord.Value.Email),Department:Text(ThisRecord.Value.Department),JobTitle:Text(ThisRecord.Value.JobTitle)}), FileNamewithExt: Text(Value.FileNamewithExt), RequestType: Text(Value.RequestType), RequestDescription: Text(Value.RequestDescription), Comments: Text(Value.Comments) } ) )

Now, you can use below formula in DefaultSelectedItems:

First(colTaskResult).Approvers

Best regards,

Was this reply helpful? Yes No