Yes that's possible and fairly easy! 

Query your list items using a Query List Action and store the IDs in a collection variable. Then use a Foreach Loop Action to iterate through each ID in the collection. Again use a Query List Action to retrieve the required data from the list. Then inside the loop use a Build String action to get the desired output in your case it is something like this: ">{"Title":"server1","WarrantyExpirationDate":"2017-05-20T04:00:00Z"},{"Title":"server2","WarrantyExpirationDate":"2017-06-03T04:00:00Z"}]"

Finally after the loop ends you can add your Email Notification Action and set the body of the email to the variable of Build String action.

Hi Shaikha and thank you for your response;

the build string variable after the loop keeps only the last loop variables (not all of them), any idea how to keep all variables !!

 my workflow :

i got only the last iteration variable : 

any idea how to get both iterations at one String/variable ?

thank you fro your help in advance;

Ahmed

Hi Ahmed,

Put the Output Variable DeviceName_expdate to the string input also. so that the previous value will be stored properly. Hope this helps. 

Hi Rogelio; thank you for your response;

i don't have only 2 records in my loop, i have a query list which have a collection output, then i have to loop/for each  record in this collection. so i don't know how many records i will have. in that example i have 2 record and i want to store each field of the collection in a variable and after the loop send all items/variables in one email.

here is simple example :

list : Server    | Exp Date

         Server1 | 12/01/2012

         Server2 | 03/02/2015

         Server 3|  02/06/2017

         server4  | 05/12/2016

- How to create a workflow that send all this items in "one" email; (if you just use a collection variable the output/print is not good, i got something like

3{"Title":"server1","WarrantyExpirationDate":"2017-05-20T04:00:00Z"},{"Title":"server2","WarrantyExpirationDate":"2017-06-03T04:00:00Z"}]").

thank you for your help!

Ahmed

Hi Ahmed.

Inside your Build String action you should add the build string variable at the end so each time the loop runs it doesn't overwrite the variable values. 

The for each loop will run for all the IDs stored in the collection therefore you need not to know how many items there.

But one question I have. What type of variable are you using to store the items is it single line or multi-line?