How to Use SharePoint Item ID or GUID for Unique References in Power Automate
Question details
The user needs a reliable way to uniquely identify SharePoint list items in Power Automate logs when the same numeric item ID can appear in multiple SharePoint lists.

- Product
- Microsoft SharePoint / Power Automate
- Device & OS
- not provided
- Scenario
- The user is logging changes from multiple SharePoint lists with Power Automate and needs Power BI or audit logs to distinguish source items accurately.
- Observed behavior
- Using only the SharePoint item ID is not unique across lists because different lists can reuse the same numeric ID, causing reporting and audit ambiguity.
Confirm you have access to the SharePoint site and can edit list views or Power Automate flows. In SharePoint, each list item has a hidden GUID field; use that field directly, or combine the list identifier with the item ID when exporting data.
Use the SharePoint item GUID as the globally unique reference
Use this when you need a single value that remains unique across all SharePoint lists and sites and can be exported to Power BI or audit logs.
SharePoint assigns every list item a GUID that does not repeat across lists in the same way numeric IDs do. Capturing the GUID in Power Automate gives you a stable, globally unique reference for reports and audit records.
In Power Automate, use the 'Send an HTTP request to SharePoint' action, or open the SharePoint list and ensure the GUID column is available in the source data.
Use the endpoint _api/web/lists/getbytitle('ListName')/items?$select=Id,GUID in the SharePoint HTTP request action so the flow output includes both the numeric ID and the GUID.
Map the GUID value to your Power BI dataset, audit log, or destination table so each row references the unique SharePoint item instead of only the numeric ID.
Combine list identifier and item ID as a composite key
Use this when you cannot retrieve the GUID or need a lightweight, human-readable key that still distinguishes items across lists.
Try WPS Office for Working with SharePoint-Exported Audit Data and Documents
WPS Office is a free, lightweight Office alternative that can open and edit SharePoint-exported Excel workbooks, CSV logs, Word documents, and PowerPoint files with full Microsoft Office format compatibility. While the GUID or composite key must be created in SharePoint/Power Automate, WPS provides a familiar ribbon interface for reviewing and analyzing the exported data.
- 1. Download WPS Office Free: Go to the official WPS Office website and click the download button to install the free version.
- 2. Open SharePoint-exported files: Launch WPS Office and open the exported Excel workbook or CSV log that contains the SharePoint GUID or composite key.
- 3. Review and analyze the data: Use the familiar ribbon tools in WPS Office to filter, sort, or format the unique reference columns for Power BI or audit reporting.

Frequently Asked Questions
How do I get the SharePoint item GUID in Power Automate?
Use the SharePoint 'Send an HTTP request to SharePoint' action with an endpoint such as _api/web/lists/getbytitle('ListName')/items?$select=Id,GUID. Alternatively, make the GUID column visible in the SharePoint list view and select it when exporting data.
Can I use item ID together with the list ID instead of the GUID?
Yes. Capture the list ID or list name in Power Automate and concatenate it with the numeric item ID to form a composite key. If the same list name can exist in multiple sites, also include the site ID or site URL.
Why does the same item ID appear in more than one SharePoint list?
SharePoint assigns numeric IDs independently within each list, so two lists can both contain an item with ID 1, 2, or any other number. The numeric ID is only unique inside a single list unless you combine it with a list or site identifier.
Is the SharePoint GUID the same as the item ID?
No. The item ID is a numeric value that can be reused across lists. The GUID is a globally unique identifier assigned to the item and is a safer unique reference for cross-list reporting and audit logs.
Can WPS Office edit SharePoint list items directly?
WPS Office cannot change SharePoint Workflow/Power Automate metadata directly, but it can open and edit documents and exported reports from SharePoint, including Excel and CSV audit logs, with full Office format compatibility.




