Hi All
I have SQL spitting out a XML file with different data as below:
<?xml version="1.0" encoding="utf-8"?>
<Job>
<JobNo>135573</JobNo>
<Customer>MC Printing</Customer>
<JobName>Sheet 26</JobName>
<LastOp>Not Started</LastOp>
<DateIn>2024-02-07T00:00:00</DateIn>
<CustOrderNo>012457MC</CustOrderNo>
<QuantityOrdered>1.165000000000000e+005</QuantityOrdered>
</Job>
I am taking elements of this data and populating a Excel spreadsheet, the issue is the QuantityOrdered number which is been produced by the SQL as a scientific number, is there a way to convert this to a full number to add to the Excel sheet within the PowerAutomate Flow, I do not want to have to convert this each time on the Excel sheet
Thanks
