https://community.blueprism.com/t5/Product-Forum/Sharepoint-vlookup-column-not-visible-in-Blue-Prism/m-p/73330#M25935 Hello,<BR /><BR />I use oledb to extract SHP List to Blue Prism Collection. Attachment "SHP_List_View" <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="15191.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/15354i31F8F648E7A00BC7/image-size/large?v=v2&amp;px=999" role="button" title="15191.png" alt="15191.png" /></span></DIV> <BR /><BR />My List contains column which is a lookup column on another list. Columns Names: NA, EMEA, APAC, LAR<BR /><BR />When I get this list to Blue Prism collection lookup columns are missing. Attachment "BP_List_View"<BR /> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="15192.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/15355iB45B79F016049F34/image-size/large?v=v2&amp;px=999" role="button" title="15192.png" alt="15192.png" /></span></DIV> <BR /><BR />Settings of Column NA are in attachment "Column NA Settings"<BR /> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="15193.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/15357iDB6D7E6A8031B350/image-size/large?v=v2&amp;px=999" role="button" title="15193.png" alt="15193.png" /></span><BR /><BR />This columns allows multiple values. I was able to extract lookup column which does not allow multiple values<BR /><BR />Do anyone has solution for this problem?<BR /><BR />Thank you in advance&nbsp;</DIV><BR /><BR />------------------------------<BR />Mateusz Wojcik<BR />RPA Programist<BR />Rockwell Automation<BR />Europe/Warsaw<BR />------------------------------<BR /> Wed, 04 Mar 2020 11:27:00 GMT MateuszWojcik 2020-03-04T11:27:00Z https://community.blueprism.com/t5/Product-Forum/Sharepoint-vlookup-column-not-visible-in-Blue-Prism/m-p/73330#M25935 Hello,<BR /><BR />I use oledb to extract SHP List to Blue Prism Collection. Attachment "SHP_List_View" <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="15191.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/15354i31F8F648E7A00BC7/image-size/large?v=v2&amp;px=999" role="button" title="15191.png" alt="15191.png" /></span></DIV> <BR /><BR />My List contains column which is a lookup column on another list. Columns Names: NA, EMEA, APAC, LAR<BR /><BR />When I get this list to Blue Prism collection lookup columns are missing. Attachment "BP_List_View"<BR /> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="15192.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/15355iB45B79F016049F34/image-size/large?v=v2&amp;px=999" role="button" title="15192.png" alt="15192.png" /></span></DIV> <BR /><BR />Settings of Column NA are in attachment "Column NA Settings"<BR /> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="15193.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/15357iDB6D7E6A8031B350/image-size/large?v=v2&amp;px=999" role="button" title="15193.png" alt="15193.png" /></span><BR /><BR />This columns allows multiple values. I was able to extract lookup column which does not allow multiple values<BR /><BR />Do anyone has solution for this problem?<BR /><BR />Thank you in advance&nbsp;</DIV><BR /><BR />------------------------------<BR />Mateusz Wojcik<BR />RPA Programist<BR />Rockwell Automation<BR />Europe/Warsaw<BR />------------------------------<BR /> Wed, 04 Mar 2020 11:27:00 GMT https://community.blueprism.com/t5/Product-Forum/Sharepoint-vlookup-column-not-visible-in-Blue-Prism/m-p/73330#M25935 MateuszWojcik 2020-03-04T11:27:00Z