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

XML Data

I have a simple XML file that I would like to import into the CDS using the New Entity from Data.  I locate the XML file which is on my companies Sharepoint and it loads it and I can see 4 columns (Name, Namespace, Value and Attributes).  Below those headers I have 1 line of information, Detail, nothing in Namespace, then [Table] in Value and [Table] in Attributes.  If i click the Value [Table] link i now see the same column headers as before but I see the word data in the Name column and there are 43 lines (which is the number of employees).  If I click the [Table] in the Value column again i finally get to the data that I need, 3 bits of information showing employee Clock, Name and In-Out.

How do I choose the right primary key, it should be the Clock and all I want is those 3 pieces of data

4 REPLIES 4
Leo09
Helper V
Helper V

can you share your xml file here? Or a similar XML file and remove the sensitive data.

<?xml version="1.0" encoding="utf-8" ?> 
- <detail>
- <data>
  <Clock>101</Clock> 
  <Name>Alan H</Name> 
  <In-Out>1</In-Out> 
  </data>
- <data>
  <Clock>149</Clock> 
  <Name>Darshan Brar</Name> 
  <In-Out>1</In-Out> 
  </data>
- <data>
  <Clock>215</Clock> 
  <Name>Clare M</Name> 
  <In-Out>1</In-Out> 
  </data>
- <data>
  <Clock>280</Clock> 
  <Name>Stewart B</Name> 
  <In-Out>1</In-Out> 
  </data>
- <data>
  <Clock>371</Clock> 
  <Name>Jan A</Name> 
  <In-Out>1</In-Out> 
  </data>

This is a few lines of the XML I am looking to import in CDS

Is the XML is the correct format? 

Is there documentation posted on how to use XML's with the import? I get to the first pic and select next and then in the next pic I am not sure what to select to correct the error.  The XML I am trying to import is in Post #3 in this thread

Pic1.pngPic2.png

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,422)