For Each loop with XML nodes to Powerapps table columns

Copper Contributor

Hi Team,

 

I'm new to ADF and struggling with an issue. Kindly help.

I'm trying to read an xml file in ADF and passing the values to Dataverse table.

 

I have a xml like below. Please suggest how to iterate through each <row> within <data> node and each <c> within <row> and paste those values to Dataverse table.

 <report>
<define>
<tableAttributes class="wefefeqweqwRTc"/>
<detailHdr>
<c>abc</c>
<c>xyz</c>
<c>Far</c>
<c>ac</c>
</detailHdr>
</define>
<data>
<row>
<c>11/16/2021</c>
<c>12/27/2021</c>
<c>91ewere</c>
<c>4erwe>
<c>Fweewe</c>
</row>
<row>
<c>11/29/2021</c>
<c>12/27/2021</c>
<c>9100wfewfewq</c>
<c>5 ewcs</c>
<c>efweO</c>
</row>
</data>
</report>

1 Reply

Anybody has any idea about it and any suggestions please