cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SlavaS1
Helper I
Helper I

XML get nodes name (Planner)

I need to get Planner's attachments. I use XML form the output 'Get task detail" step.

I am able to get the value of the 'alias' field however I got stuck on getting higher node name due to it variance, for example, I need to get these values:

  • "https%3A//demoppm4%2Esharepoint%2Ecom/sites/pe-energy2/Shared Documents/PE-Energy%2520logo%2Epng?web=1"
  • "https%3A//demoppm4%2Esharepoint%2Ecom/sites/pe-energy2/Shared Documents/Template%2520EMPLOYEE%2520PERSONAL%2520INFORMATION%2520FORM%2Edocx?web=1"

My XML is:

 

{
  "root": {
    "https%3A//demoppm4%2Esharepoint%2Ecom/sites/pe-energy2/Shared Documents/PE-Energy%2520logo%2Epng?web=1": {
      "@odata.type": "#microsoft.graph.plannerExternalReference",
      "alias": "PE-Energy logo.png",
    },
    "https%3A//demoppm4%2Esharepoint%2Ecom/sites/pe-energy2/Shared Documents/Template%2520EMPLOYEE%2520PERSONAL%2520INFORMATION%2520FORM%2Edocx?web=1": {
      "@odata.type": "#microsoft.graph.plannerExternalReference",
      "alias": "Template EMPLOYEE PERSONAL INFORMATION FORM.docx",
    }
  }
}

 

 

 Could you help me how to get the first (after "root") node names?

 

Thanks for advance!

1 ACCEPTED SOLUTION

Accepted Solutions

 

Hi @SlavaS1 ,

 

Unfortunately, Power Automate currently does not support such data operations. If you want similar features to be supported, please consider submitting your suggestions in the ideas forum:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/MPAIdeas

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Mira_Ghaly
Dual Super User II
Dual Super User II

@SlavaS1 

I have simulated the same at my side , i added the JSON to Variable as below and then used Parse JSON action, and for the schema used the below:

{
    "type""object",
    "properties": {
        "root": {
            "type""object",
            "properties": {
                "https%3A//demoppm4%2Esharepoint%2Ecom/sites/pe-energy2/Shared Documents/PE-Energy%2520logo%2Epng?web=1": {
                    "type""object",
                    "properties": {
                        "@@odata.type": {
                            "type""string"
                        },
                        "alias": {
                            "type""string"
                        }
                    }
                },
                "https%3A//demoppm4%2Esharepoint%2Ecom/sites/pe-energy2/Shared Documents/Template%2520EMPLOYEE%2520PERSONAL%2520INFORMATION%2520FORM%2Edocx?web=1": {
                    "type""object",
                    "properties": {
                        "@@odata.type": {
                            "type""string"
                        },
                        "alias": {
                            "type""string"
                        }
                    }
                }
            }
        }
    }
}

 

Mira_Ghaly_0-1599130673880.png

then you can access the properties as below:

 

Mira_Ghaly_0-1599130789473.png

 

 

 

 

 

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Hi  @Mira_Ghaly , thank you for your reply.

The point is I need to get the property name and not the property's value due to the property name depends on the attachment name, moreover the quantity of properties are different depends on the task attachments

https://www.screencast.com/t/6vLzE0gJ

 

So could you advise how to get this text

https://www.screencast.com/t/cpdQaOWZ2nF

 

Hi @SlavaS1 ,

 

Unfortunately, Power Automate currently does not support such data operations. If you want similar features to be supported, please consider submitting your suggestions in the ideas forum:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/MPAIdeas

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (44,150)