SharePoint Document Issues

How to Use SharePoint Item ID or GUID for Unique References in Power Automate

John WilsonJohn Wilson Nov 13, 2026 871 views

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.

How to Use SharePoint Item ID or GUID for Unique References in Power Automate
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the list or use the SharePoint REST API

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.

2
Select the GUID field in the flow output

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.

3
Store the GUID in your log or dataset

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.

Result: Each logged change now has a globally unique item reference, and identical numeric IDs in different lists no longer cause reporting collisions.
Free Microsoft Office alternative

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. 1. Download WPS Office Free: Go to the official WPS Office website and click the download button to install the free version.
  2. 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. 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.
Opens and edits SharePoint-exported Excel, CSV, Word, and PowerPoint files without extra licensingFull compatibility with .xlsx, .docx, .pptx and other Microsoft Office formatsLightweight and familiar ribbon-based interface for quick adoptionFree to download and use, making it easy to review audit logs and reports on any workstation
microsoft office alternative - wps office

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.