web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sharepoint list - when...
Power Automate
Answered

Sharepoint list - when column value modified

(0) ShareShare
ReportReport
Posted on by 192

Hi all,

I want to create a flow that when the column value of 'customer status' change it will change the position the same item in the hub navigation.

for example if I change the 'customer status' of "PFG" to "On Boarding" in the navigation it will change his position under the "On Boarding" Label.

lidor_dayan_0-1673533097730.png

lidor_dayan_1-1673533353929.png

 want to know if it is possible because I didn't find something that show how to do that.

Thanks for your help!

 

Categories:
  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @lidor_dayan  Use send http request action to change navigation. See this thread-

    https://powerusers.microsoft.com/t5/General-Power-Automate/HTTP-Request-to-update-SharePoint-navigation-node/td-p/1863967

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

  • Expiscornovus Profile Picture
    33,997 Most Valuable Professional on at

    Hi @lidor_dayan,

     

    You would want to create a sublink, correct?

     

    @Hardesh15 already steered you into the right direction. The only thing I want to add would be that in this you also need to retrieve the node id of the Onboarding header and use the Children method as well. This way it will become a sublink.

     

    Below is an example to create a navigation node as a sublink under an existing Label node.

    This example only creates the link in the correct place.

     

    You also need to remove the link under BAU with a separate HTTP request. If you need help with that part as well, let us know?

     

    _api/web/Navigation/GetNodeById(@{outputs('Send_an_HTTP_request_to_SharePoint_-_Get_Onboarding_Node_Id')?['body']['d']['results'][0]['id']})/Children

     

    {
     "Accept": "application/json; odata=verbose",
     "Content-Type": "application/json; odata=verbose"
    }

     

    { 
     "__metadata": { type: "SP.NavigationNode" }, 
     "IsExternal": true, 
     "Title": "Power Automate Test", 
     "Url": "https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity" 
     }

    createsublinkinnavigation.png

     

     

  • lidor_dayan Profile Picture
    192 on at

    Hi @Expiscornovus, could you Help me with the remove link under BAU with a separate HTTP request?

     

  • Verified answer
    Expiscornovus Profile Picture
    33,997 Most Valuable Professional on at

    Hi @lidor_dayan,

     

    You can use a DELETE request together with the getbynodeid method. 

     

    Below is an example

    I used a couple of additional GET requests to spot the right node within BAU.

     

    _api/Web/Navigation/GetNodeById(@{outputs('Send_an_HTTP_request_to_SharePoint_-_Get_PFG_Node_Id')?['body']['d']['results'][0]['id']})

     

    deletenode.png

  • lidor_dayan Profile Picture
    192 on at

    Hi @Expiscornovus I need to do that for every item on the list? I have 53 Items..

  • Expiscornovus Profile Picture
    33,997 Most Valuable Professional on at

    Hi @lidor_dayan,

     

    No, that is not what I am suggesting. Currently I am only showing you how to add and remove a link in the navigation via a flow.

     

    If you need help with the when a item has changed in a list and use that information for adding/removing links part I am happy to help out with that as well?

     

    You could use a when an item is modified trigger action for that. Do you need an example for that part as well?

  • lidor_dayan Profile Picture
    192 on at

    Hi @Expiscornovus , this is what I did:

    lidor_dayan_1-1674120548279.png

    and after that I need to put the "send an HTTP request to SharePoint"?

     

    Thank you for your help!

    I'm new in this so I'm learning and trying to understand.

     

  • Verified answer
    Expiscornovus Profile Picture
    33,997 Most Valuable Professional on at

    Hi @lidor_dayan,

     

    Yes, you are pretty close 🙂 Those actions would also be the first three actions I would use.

     

    Let's focus on mapping the fields for the adding the link scenario first.

     

    The removing a link mapping is a bit more complicated because it involves retrieving version history, so that's why I would suggest to fix that after these steps.

     

    Below could be the mapping of fields of your list within the HTTP request (for the adding nav links scenario)

     

    Uri for retrieving Cluster node id

    _api/Web/Navigation/QuickLaunch?$filter=Title eq '@{triggerOutputs()?['body/Cluster/Value']}'&$select=id

     

    Uri for retrieving Customer status label node id

    _api/Web/Navigation/GetNodeById(@{outputs('Send_an_HTTP_request_to_SharePoint_-_Get_Cluster_Value_Node_Id')?['body']['d']['results'][0]['id']})/Children?$filter=Title eq '@{triggerOutputs()?['body/CustomerStatus']}'&$select=id

     

    mapping_addinglink.png 

  • lidor_dayan Profile Picture
    192 on at

    Hi @Expiscornovus it is giving me this error.

     

    outputs('Send_an_HTTP_request_to_SharePoint_-_Get_On_Boarding_Node_Id')?['body']['d']['results'][0]['id']

     

    lidor_dayan_0-1674124123002.png

    lidor_dayan_0-1674124371952.png

     

     

  • Expiscornovus Profile Picture
    33,997 Most Valuable Professional on at

    Hi @lidor_dayan,

     

    Just a couple of questions to double check.

     

    1. Did it actually find the node in the previous GET actions (can you double check in the outputs if it found ids)?

    2. Did you update to expressions to your action names. In the expression I refer to my actions names, which might be different in your setup. Be sure to update it to your setup.

     

    namesaredifferent.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 426

#2
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard