Problem in converting Page list to value list

Hi Team,

I am taking input through excel file and using MSOParseExcelFile to create a page list and trying to convert pagelist to valuelist using data transform. Where I am trying to iterate on page list that I created through excel sheet and putting it into new valuelist property throwing me an error as its not getting source page.

***Edited by Moderator Marissa to update platform capability tags****


Keep up to date on this post and subscribe to comments

August 24, 2019 - 2:28pm

Could you please share the screenshot of that Data Transform? 

August 27, 2019 - 7:32am
Response to sharp3

I am not able to attach document or screenshot due to company privacy policy.

August 26, 2019 - 11:20pm

Hi Aishwarya,

Iterate over the page list in the source using 'For Each Page In'. set the repeating value using the (<APPEND>) subscript and reference the page in the page list as the source using the (<CURRENT>) subscript.


'For Each Page In' SourcePage.PageList,

'Set' TargetPage.ValueListProperty(<APPEND>) = .PageList(<CURRENT>).PropertyName

Where the .PageList().PopertyName was the reference to a Pagelist in the current step page for the source column.

August 27, 2019 - 7:31am
Response to bhars1

I tried this way, but it still showing error as its not getting context of Source page. I have already mentioned source page in Pages and classes tab