Hi All, I have 3 different lists, there is one field / column which could be common in all 3 lists. (But Column name is different, only the values match). Now I need to pull certain data from these 3 lists and keeping this field as common reference, I need to create a report that all the items with common value (of this matching column) along with all other columns filled with matching values must be sent out as a report in email.
I am relatively new user, can someone help ?
You should be able to add a query list action and set the filter on the column value you desire. You would store the query result in a collection variable. I detailed some of these steps in a document recently, although I only used content from one list. You should be able to repeat the process to get the data from all your lists. Then once you've got all your variables populated you can create the email.