Flow structure:
My trigger gets a text string called "searchTerm" from my power app.
I'm initializing an array variable called "varSearch" (that will be sent back to the app once fully appended).
I'm using a "Get items" action and pulling in all items from my SharePoint list. (No advanced settings)
Next I have an "Filter array" with a condition statement that is returning only items where "searchTerm" is contained in any of the three columns (Title, Description, ActionsTaken).
The condition statement that has been working correctly is...
(
contains(item()?['Title'], triggerBody()['text']),
contains(item()?['Description'], triggerBody()['text']),
contains(item()?['ActionsTaken'], triggerBody()['text'])
)
In an "Apply to each" action, I want to use a "Select" action to grab only the columns I need and append each item processed to my array variable.
The "Apply to each" action configured this way...
I'm running into a problem around the work I'm trying to do inside my "Apply to each" action.
I WANT to only work with nine columns, and for the four complex columns to only return...
- 2 X Choice columns (TaskStatus & Priority) - only the selected values
- 2 X Person columns (Customer & AssignedTO) - only "DisplayName"
My "Select" action is set to handle grabbing just those columns, and it works correctly (outputs look good upon inspection after a successful run).
The issue I'm running into is with the "Append to array variable" action...
PROBLEM DESCRIPTION:
When I use the "Output" of my "Select" action as the input for "Append to array variable" action...
...the flow errors out at "Append to array variable" with the following...
NOTE:
If I use "Current item" from the "Apply to each" action as the input for "Append to array variable" action...
...the entire flow runs successfully.
But since this BYPASSES the "Select" action, the output contains ALL columns for each SP item, as well as all meta data associated with the complex columns (ie. Claims, Picture, etc... for persons)... Not what I need.
Any assistance with how I can use the output of "Select" but avoid the error in the "Append to array variable" is greatly appreciated.
End goal:
After "Apply to each" runs, my "varSearch" variable should have the filtered results, and "Respond to a PowerApp", returning the resulting array to my PowerApp...
My app receives the response from the flow, and uses "ParseJSON" to create a table, and pass the data into a collection that I display in a gallery.
