Power Platform Community Forum Thread Details

Data Transformation - Excel to EDI text file

About the only thing I have been able to get flow to do is initialize variables but have no idea how to populate them from an Excel Sheet.

I am looking to create a Flow which will allow us to pull specific cells from a NON-Tabled Excel datasource, and rewrite the data into a standard EDI format text document.

Example

Pull cell C6 into a variable - $CustomerNumber

Pull cell J12 into a variable - $OrderNumber

Pull cell J14 into a variable - $ShipDate

Pull cells B21-B1200 and J21-J1200 into a array variables - $Item and $Qty

Then write an output Text Document using a Template similar to the below...

ISA*00* *00* *ZZ*ORDERS
GS*PO*ORDERS*
ST*850*91xxxxx9~
BEG*00*SA*POSxxxxxxV*99xxxxxx9*$SHIPDATE~
PER*IC*EM*~
CAM*EARLY~
REF*SOT*1~
REF*BD*PIOR001*Order PO Number $ORDERNUMBER_RV~

ITD*01*$TERMS~
DTM*010*20190901~
DTM*001*20191016~
PO1*1*$QTY[0]*EA*xx**IT*$SKU[0]*UP*$UPC[0]
PO1*2*$QTY[1]*EA*xx**IT*$SKU[1]*UP*$UPC[1]
PO1*3*$QTY[2]*EA*xx**IT*$SKU[2]*UP*$UPC[2]