@UmaPatil2023 Are you trying to loop through the left navigation and only get the lists that appear there? IF so, then this is how I would do it (there might be an easier way).
For this example, I have 4 x lists and the following navigation.
See full flow below. I'll go into each of the actions.
Get AMERS (Send an HTTP request to SharePoint) retrieves the top-level navigation nodes. It uses the following Uri:
//Uri
_api/web/navigation/quicklaunch
Filter array extracts out the navigation node with the Title of AMERS. It uses the following expressions:
//From
outputs('Get_AMERS')?['body']?['d/results']
//Filter
item()?['Title']
Get Headers (Send an HTTP request to SharePoint) retrieves the children from the AMERS navigation node using the following Uri:
//Uri
_api/Web/Navigation/GetNodeById(@{first(body('Filter_array'))?['Id']})/Children
Apply to each Header iterates over each of the children using the following expression.
body('Get_Headers')?['d/results']
Get Lists (Send an HTTP request to SharePoint) retrieves the children from each of the Headers using the following Uri. This will give us our List links.
//Uri
_api/Web/Navigation/GetNodeById(@{item()?['Id']})/Children
Select gets the Navigation Node Title and the List Name using the following expressions.
//From
body('Get_Lists')?['d/results']
//Title
item()?['Title']
//ListName
split(item()?['Url'], '/')[4]
Apply to each List iterates over each of the Lists using the output from the Select.
Get items retrieves the items from the current list using the following expression for the List Name.
item()?['ListName']
Apply to each Item iterates over each of the items in the current list using the output (value) from Get items.
You would perform your data mapping to your SQL table(s) within this loop as per your requirements.
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
