Unable to append to array

Hi, i have a sharepoint list which stores the following information

Title | Value | Approver | Status

The Approver is a choice column that a user must select. A user can select Multiple Approvers.

I have the approval all working fine..

Now i would like to send a reminder to the approvers in case the status is still Pending.

I have started to write my flow to get me all items where Status = Pending. All Working

I am stuck on getting the approver into an array.

There could be several items in that sharepoint list that have user joe.bloggs@domain as the approver.... So i would like to get a list of all the approvers and then someone how a union on them so i get a distinct list of approvers who status is pending.

I initialized a variable of type array. .
When i apply to each SharePoint value, i use the Select statement to give me the approve value.

I then try to append the approver value from the select statement to an array, but this fails as below

The value '["joe.bloggs@domain.com","john.smith@domain.com"]' of type 'Array' cannot be appended to the variable 'Approvers' of type 'Array'. The action type 'AppendToArrayVariable' only supports values of types 'Float, Integer, String, Boolean, Object'.

The aim is to get all the approvers into a varaible so i can run a union to get a distinct number of approvers who have not approved, then send them an email asking them to approve.

Can someone please help?

Thanks

Quick Links

Leaderboard > Power Automate