Answered

Get SharePoint list name from SharePoint trigger or action

(0) Share

Report

Posted on by rameshmukka

1,123

I would like to get my SharePoint list display name to use in Uri property of HTTP Request to SharePoint action. Hardcoding the name of the list is not a good solution as the change in list name can happen any time and my flow would fail at HTTP action. So I am looking for a way to get the display name of my list dynamically before my HTTP Request to SharePoint action. Using environment variables might not help if the list names are changed any time. Assuming my List display name is "Deviations: Forms Record", I don't see this display name embedded in any dynamic content from SharePoint trigger or other SharePoint actions. Please suggest any ways.

Thanks,

Ramesh Mukka

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Expiscornovus 33,933 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RameshMukka,

As far as I am aware the environment variable of type list is using a guid. So, it should be able to handle a rename of the list. So, I would say a environment variable would be useful in this scenario.

Below is an example to demonstrate.

1. Environment variable of type data source/list

2. Setup in flow

3. Renaming the list

4. Flow still runs happily after that change, because it is using the List GUID under the hood

Was this reply helpful? Yes No
rameshmukka 1,123 on at

Like
a
(0)

Report
Copy link

Link copied!

@Expiscornovus Thank you for the response. But I am looking to use the list name dynamically in Uri property of HTTP Request to SharePoint action. I don't think I can use GUID here. Please confirm.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,933 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @RameshMukka,

Sure you can. Instead of the GetByTitle method there are other methods as well.

https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest#retrieving-lists-and-list-properties-with-rest

Try and use the following format instead:

GET https://{site_url}/_api/web/lists(guid'{list_guid}')

Was this reply helpful? Yes No
rameshmukka 1,123 on at

Like
a
(0)

Report
Copy link

Link copied!

@Expiscornovus Thanks a lot. It is working for POST method as well.

Was this reply helpful? Yes No