How to flatten/normalize multiple lists inside a dictionary in Azure Data Factory?

Question

All the existing queries are about how we can deal a single list inside a json. How to deal multiple lists within a json?

Any help in this regard would be appreciated.

Opening this payload inside flatten gives me the first list data only. The second list name and its column are not available in flatten. why?

{  
     "result": "success",  
     "err": None,  
     "data": [  
         {  
             "outcome_percent_vs_average_score": [  
                 {  
                     "name":"sadaqat",  
                     "id":12  
           
                 },  
                 {  
                     "name":"sadaqat1",  
                     "id":123  
           
                      
                 }  
             ]  
         },  
      
         {  
             "average_criteria_score": [  
                 {  
                 "avg_id":123,  
                 "avg_name":"hello"  
                 },  
      
                 {  
                 "avg_id":1234,  
                 "avg_name":"hello 1"  
                 }  
             ]  
         }  
     ]  
 }  

You can see the first list is being shown in the flatten activity not the others are there.

How to flatten both the lists in flatten activity?