cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Karamon
New Member

How to get GUID of Sharepoint list items

Hello,

 

I'm trying to get GUID of Sharepoint list items.

 

If I connect to a list from PowerBI, I can find the GUID column of the list.

Karamon_0-1661246382186.png

However in Power Automate, when I am trying to get list data by "Get items" and "Apply to each" connectors

Karamon_0-1661246806469.png

 

it seems that this column is missing, however some other hidden columns can be found (e.g, Author or Editor informaion)

Karamon_1-1661246465964.png

Is there any way to get GUID data of list items? thank you.

 

1 ACCEPTED SOLUTION

Accepted Solutions
CFernandes
Super User
Super User

Hey @Karamon 

 

Use REST API - 

CFernandes_0-1661247543394.png

 

/_api/web/lists/getByTitle('List')/items?$select=GUID

 

change 'List' with your listname

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

 

View solution in original post

1 REPLY 1
CFernandes
Super User
Super User

Hey @Karamon 

 

Use REST API - 

CFernandes_0-1661247543394.png

 

/_api/web/lists/getByTitle('List')/items?$select=GUID

 

change 'List' with your listname

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,545)