Power Platform Community Forum Thread Details

I have this Filter Array action:-

The outputs(FomrJsonAddedValue) will have this format:-

{"OOH.2m2.2024.7.1085":{"OOH_media_list":[{"Network":"Flawless A","Amount":"10500.000","Duration":"2 week","of_Faces":"25","Start_Date":"29-Jul-2024","End_Date":"11-Aug-2024","type":"Out_Of_Home","Delivery Date":"29-Jul-2024"},{"Network":"Flawless B","Amount":"10500.000","Duration":"2 week","of_Faces":"25","Start_Date":"29-Jul-2024","End_Date":"11-Aug-2024","type":"Out_Of_Home","Delivery Date":"29-Jul-2024"},{"Network":"Velvet A","Amount":"19000.000","Duration":"2 week","of_Faces":"50","Start_Date":"29-Jul-2024","End_Date":"11-Aug-2024","type":"Out_Of_Home","Delivery Date":"29-Jul-2024"},{"Network":"Velvet B","Amount":"19000.000","Duration":"2 week","of_Faces":"50","Start_Date":"29-Jul-2024","End_Date":"11-Aug-2024","type":"Out_Of_Home","Delivery Date":"29-Jul-2024"}],"Email":"******","Category":[],"Sales Person Email":"*****","Contract Number":"OOH.2m2.2024.7.1085","Client Name":"MindShare","Sector":null,"Financial_Accountant_Email":"******","Tax_Registration_Number":"16664159","Blue_River_No":"P.OOH.2m2.2024.7.1101","Contact":["Ms. R****"],"Brand":"Arab Bank ","OOH_price_list":{"Net_Total":"50150.000","Grand_Total":"58174.000","Sales_Tax":"16.00","Total":"59000.000","DIscount":"15.00","Amount_in_Words":"Fifty Eight Thousand One Hundred Seventy Four"},"BR_price_list":null,"blue_river_list":[],"Financial_Accountant_Name":"Ahmad Awwad","Select_Customer_Type":"Agency","No_Of_Faces_Production":null,"No of Faces":"150","Sales Person Name":"D***"},"OOH.2m2.2024.7.1120":{"OOH_media_list":[{"Network":"Flawless C","Amount":"5250.000","Duration":"1 week","of_Faces":"25","Start_Date":"30-Jul-2024","End_Date":"05-Aug-2024","type":"Out_Of_Home","Delivery Date":"30-Jul-2024"},{"Network":"Velvet Booster B","Amount":"14250.000","Duration":"1 week","of_Faces":"75","Start_Date":"31-Jul-2024","End_Date":"06-Aug-2024","type":"Out_Of_Home","Delivery Date":"31-Jul-2024"}],"Email":"****","Category":[],"Sales Person Email":"****","Contract Number":"OOH.2m2.2024.7.1120","Client Name":"MindShare","Sector":null,"Financial_Accountant_Email":"***","Tax_Registration_Number":"16664159","Blue_River_No":null,"Contact":["Ms. Rana Elayyan"],"Brand":"Mercedes ","OOH_price_list":{"Net_Total":"16575.000","Grand_Total":"19227.000","Sales_Tax":"16.00","Total":"19500.000","DIscount":"15.00","Amount_in_Words":"Nineteen Thousand Two Hundred Twenty Seven"},"BR_price_list":null,"blue_river_list":[],"Financial_Accountant_Name":"****","Select_Customer_Type":"Agency","No_Of_Faces_Production":null,"No of Faces":"100","Sales Person Name":"*****"}}

but the Filter Array will raise this error:-

any advice?

Thanks

Categories:

Building flows

Hi,

The error is happening because you are passing the whole output from your outputs(FomrJsonAddedValue), which in this case is an object, to a Filter array that expects an array. I'm assuming here that what you actually want to filter is the OOH_media_list property, which is an array. A strategy to quickly identify if a property is an object or an array is to check its opening character: if you have a square bracket, it's an array; if you have a curly bracket, it's an object.

Let's take the beginning of your outputs(FomrJsonAddedValue) as example: {"OOH.2m2.2024.7.1085":{"OOH_media_list":[{"Network":

Your whole outputs(FomrJsonAddedValue) is an object, as it starts with a curly bracket (in yellow)
your OOH.2m2.2024.7.1085 property is an object, as its value starts with a curly bracket (in green)
your OOH_media_list property is an array of objects, as its value starts with a square brackets, followed by a curly bracket (in red).

Solution

To access the values from OOH_media_list property, you can use the following expression as input to your Filter array: json(outputs(FomrJsonAddedValue))['OOH.2m2.2024.7.1085']['OOH_media_list'].

If your goal is not exactly to filter the values from OOH_media_list, please provide us with more context on what do you need.

Knowledge base

As reference for you or any user that finds this thread in the future, I'm also sharing some articles that I wrote about the topics discussed here, as they can bring additional understanding about this confusion between objects and arrays:

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/

https://www.linkedin.com/in/raphael-haus-zaneti/