I am creating a flow to send emails to users . My list has around 45k items in it . I created below flow to fetch all my items in less time . Now I am trying to separate the site title, owners , admins into different variables but got confused how to do it. can anyone guide me to proceed further.
I am basically concerned about collecting admin and owners details into separate variables . I am stuck and facing challenges in getting these two fields data appended into my variables created at beginning .
Can anyone in the forum guide me on this .
Thanks for the help in advance.
For extracting the data from json body you can try as below
1. After using the parse json, utilise the body parameter which is coming as output from parse json
for eg: i had used a json like this
Now used this expression to extract the name data from the json
I used as you suggested but the output is blank in my case evwn though flow ran successfully.
I used as below to extract tittle of the sites for eg but it gave blank page when i try to download the output.
In your case, you had loop through the parsed json output and get the indiviual items from it
I had taken json like this
Now after parsing json i used Apply For Each action to loop through each element of body and extracted the required data
like as below
In compose i had used the expression to extract the name from json
expression as below
Mark it as solution if it helps
Thanks for the help . The way you guided worked for me. i need more assistance for further steps . I am able to extract my owners and admins into two variables separateley . total no of users are around 4200. Now I have to check for every user how many sites they are owner or admin and list out those . I tried with by hardcording one user in filter array action but got some errors .
I am getting desired values . Now when I try to collect all values in my variable it gives me error "The variable of type 'Array' cannot be initialized or updated with value of type 'String'. The variable only supports values of types 'Array'". how i can have unique values of my owners and admins in my variables initialized at the beginning.