I saw an archived post about this issue and wanted to share the technical root cause and solution for future searchers.
The Problem:
During a Power Platform solution import or pipeline deployment, a specific SharePoint site is missing from the Connection Reference dropdown menu, even though the deploying account (e.g., a Service Account) has full access to the site.
Original error message:
"Warning: You do not have access to the site value for this selected connection. However, this does not block other users in the target environment from using this site value if they have access."
The Technical Root Cause:
The dropdown UI does not query all accessible sites. It uses the Azure API Hub (/datasets endpoint), which relies on the Microsoft Graph API's "Recent Sites" and (maybe) "Followed Sites" lists. If the Microsoft Graph hasn't registered the site as "recently used" by the deployment account, it won't appear in the UI.
The SharePoint Site must appear in the search results, this is mandatory for listing the SharePoint Site in the "Recent Sites".
How to permanently fix the Dropdown UI (Force Graph Sync):
If you need the site to appear in the UI, apply these two fixes to force the Microsoft Search Index and Graph API to recognize the site:
- Fix the "Owner vs. Member" Quirk: Ensure the Service Account is explicitly added as a Member of the M365 Group/SharePoint Site, not just an Owner. Microsoft background syncs often fail to push sites to the "Recent" list if the account is only an Owner.
- Re-index the Site: The Graph API relies entirely on the SharePoint Search Index. Go to Site Settings > Search and offline availability and click Reindex site. The SharePoint Site must finally appear in the search results!
Note: After applying these changes, it can take anywhere from 15 minutes to 24 hours for the Microsoft Graph API to update its cache and populate the /datasets endpoint used by the Power Platform UI.