I have to generate an excel sheet using a page list , which in turn consists of multiple page lists inside it . I am trying to use MSOGENERATEEXCELFILE OOTB activity for the same but I am getting an error .
I am trying this syntax "WorkPageList.pxResults().FieldValues().pyLabel input"
where WorkPageList.pxResults() is my top level page list and FieldValues() is one of the page list inside it .
My issue has been resolved . We can't use a nested page list in the MSOGenerateExcelFile activity . I am populating the data in a simple page list (not nested ) and using the same to build my excel .