Unanswered

ID not working as a consistent identifier

(0) Share

Report

Posted on by zach2161

I am currently working on a flow that automatically creates a Sharpoint page and populates it for every item added to a list called "Departments." Everything that I have found online is pointing me towards this type of implementation when it comes to checking out my created page.

Screen Shot 2021-07-22 at 4.42.27 PM.png

This does work, however, ID is not behaving as a consistent identifier for these pages. I have many other pages on my site so filtering by ID does not return the same page as the ID of my list items. For example:

The ID values alongside each item in my "Departments" list

Screen Shot 2021-07-22 at 4.43.56 PM.png

The ID values alongside each page in my "Departments" pages folder

Screen Shot 2021-07-22 at 4.43.38 PM.png

Is there a better way I can access these files programmatically? Maybe a way to gather them by Document ID or Title?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Expiscornovus 33,773 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @zach2161,

Just to double check. You are using the out of the box ID fields? If so, the ID is a unique field in the list itself and in no sense related the ID field of another list or in your case site pages library.

If you want to create a relationship between the list and the library you need to create that yourself. I would suggest to add additional column to the site pages library. Call it DepartmentListID and set that value whenever you create a new page.

Was this reply helpful? Yes No
zach2161 26 on at

Like (0)

Report
Copy link

Link copied!

Thank you @Expiscornovus,

You're right that is the way I was previously using ID. I'm working on creating a unique DepartmentListID to each item, how would I go about adding that same ID to each page? I know I can do UpdateItem to add that value to a list item, how can I add the value to a page?

Was this reply helpful? Yes No
Expiscornovus 33,773 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @zach2161,

After you have create a page in your flow you should be able to set the properties of that page via update file properties action.

Below is an example of that.

In that example I am using the expression below to retrieve the id of the page.

outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']['Id']

In the DepartmentListId I am using the id of the Department list from a Get Items within an apply to each, just like in your screenshots.

items('Apply_to_each')?['ID']

Was this reply helpful? Yes No