The Office 365 Sharepoint Connector functionality for pulling data from the SiteUsers table needs a subsite path parameter, like found in searches for several other Sharepoint tables. As the SiteUsers are specific to a site (including sub-sites), there is no functionality to get the list of users for a specific sub-site. It can be accomplished by adding the site to the Base URL, but as the same web connector is used for several site searches, this breaks the search.
We are extracting list data from Sharepoint generated by a PowerApp, and the list entry contains a field OwnerID. In Qlik, we also need the OwnerName field, which in this case can be derived from the SiteUsers table. However, due to the site-specific of site-users, the current functionality for the O365 Sharepoint Connector only fetches SiteUser data for the root Sharepoint site (Base URL), not any specific subsite, so the match based on OwnerId is wrong. These subsites can not be defined in the connection string either.