Hi Andrew Wilkie‌,

If you want to pull the information of sub list from an existing list, you need a unique column present in both lists. Do you have any such column in your 2 lists. If there we can use Nintex site workflow to send emails.

Thanks,

‌

No unique column in both lists. These are inbuilt SharePoint lists.

Hi Andrew,

this is only one single list. The "sub list" is actually a folder inside this list (you can see that if you change your view to include the "type" column). Thus you should be able to query these items by simply querying the list and setting the "Recursive" flag inside the query list action.

Quoted from the actions help: "Recursive - Check this option to query for items within folders and subfolders."

Best Regards

Philipp

Thanks Philipp, I kept seeing the word folder in the url too.

This seems to work for new initial posts, yet I can't  seem to get the reply, maybe I need another query for replies?

****update*****

Having just done a run now against the query I see the following:

Title:
 Andrew Wilkie said...
 Andrew Wilkie replied...
ContentData:
 <CDC xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://Microsoft/Office/Server/SPMicrofeedContentDataCollection"><a xmlns:d2p1="http://Microsoft/Office/Server/Microfeed"><d2p1:CD><d2p1:a>ContentUri</d2p1:a><d2p1:b i:nil="true" /><d2p1:c>https://domain.com/Lists/PublishedFeed/FEB96200-6E92-41DB-856B-E8702BCDF33A</d2p1:c><d2p1:d i:nil="true" /></d2p1:CD></a></CDC>
 
SearchContent:
 This is my first post in my site beta newsfeed
 How about a reply
Attributes:
 0
 0
PostAuthor:
 HORWATHwilkiea
 HORWATHwilkiea
ID:
 3
 4
ReferenceID:
 

It's picking up all the detail, think I might need to do a for each ID ?
 

****update 2******

Working now with the following: The key is both query lists need to have the recursive option selected.

Andrew