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
<?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 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
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Check out the Power Apps Community Call for January 2021
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!