https://community.qlik.com/t5/App-Development/Pull-data-from-SharePoint-List-quot-Created-By-quot-column/m-p/2011905#M83665 <P>Hi everyone,</P> <P>When pulling data from a SharePoint list, I found the "Created By" column with text values become numbers in Qlik. The "Created By" (column name in SharePoint) becomes "Author ID" (column name in Qlik).</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2022-12-02_15h35_27.png" style="width: 396px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/95228iC2025C03F3BE57DD/image-dimensions/396x302?v=v2" width="396" height="302" role="button" title="2022-12-02_15h35_27.png" alt="2022-12-02_15h35_27.png" /></span></P> <P>In SharePoint The "Created By" column value is generated automatically according to SSO information that shows display name of the current user. Hover on it we can see more details about the person, e.g. email address, department, ...</P> <P>Does anyone know how to get the correct value as display name, and email address?</P> <P>Thanks.</P> Fri, 02 Dec 2022 07:36:57 GMT stillcloud 2022-12-02T07:36:57Z https://community.qlik.com/t5/App-Development/Pull-data-from-SharePoint-List-quot-Created-By-quot-column/m-p/2011905#M83665 <P>Hi everyone,</P> <P>When pulling data from a SharePoint list, I found the "Created By" column with text values become numbers in Qlik. The "Created By" (column name in SharePoint) becomes "Author ID" (column name in Qlik).</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2022-12-02_15h35_27.png" style="width: 396px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/95228iC2025C03F3BE57DD/image-dimensions/396x302?v=v2" width="396" height="302" role="button" title="2022-12-02_15h35_27.png" alt="2022-12-02_15h35_27.png" /></span></P> <P>In SharePoint The "Created By" column value is generated automatically according to SSO information that shows display name of the current user. Hover on it we can see more details about the person, e.g. email address, department, ...</P> <P>Does anyone know how to get the correct value as display name, and email address?</P> <P>Thanks.</P> Fri, 02 Dec 2022 07:36:57 GMT https://community.qlik.com/t5/App-Development/Pull-data-from-SharePoint-List-quot-Created-By-quot-column/m-p/2011905#M83665 stillcloud 2022-12-02T07:36:57Z