cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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
Highlighted
Community Support
Community Support

Re: XML get nodes name (Planner)

 

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
Highlighted
Resident Rockstar
Resident Rockstar

Re: XML get nodes name (Planner)

@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.
Highlighted
Frequent Visitor

Re: XML get nodes name (Planner)

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

Highlighted
Community Support
Community Support

Re: XML get nodes name (Planner)

 

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,161)