Getting a SharePoint Item ID from the URL

(0) Share

Report

Posted on by olliewebbuk

Hi all,

I'm looking at a process in Power Automate that grabs a new item from a SharePoint list, created a MS Planner task, and then when that task is completed I want it to grab the details of the original SharePoint Item to create an Item in a new List.

The Task in Planner has the original SharePoint Item that was used for it's creation as an attached URL.

Does that make sense?

I can't figure out how to capture this original SharePoint Item using the direct URL to it - the URL is fine as when I click it my browsers goes straight to it. But I can't seem to get Power Automate to capture it. I've tried using the Get Item function but it just doesn't want to know.

Any ideas folks? I'm super new to Power Automate and this is the first time I've tried to use it.

Perhaps there's another way of keeping a reference to the original SharePoint Item in MS Planner that I'm missing?

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (0)

Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!
@olliewebbuk

I would suggest that you append the SharePoint List ID on the Planner Task as below:

Then when the task is completed use the Split Expression below to get the id from the Title as below:

Expression:

split(triggerOutputs()?['body/title'],'-')[1]

Then use the Get Item and pass the ID from the compose Data Operation to get the item from the Old List.

Hope this makes sense to you!

Was this reply helpful? Yes No