You’re offline. This is a read only version of the page.
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]
Hi @dowens81625 ,
Unfortunately, the actions contained in the Excel connector can only operate on the data in the Excel table.
The prerequisite is that the table has been defined in the Excel file and the data is stored in the table.
If you want similar features to be supported by MS Flow, please consider voting for the following idea:
https://powerusers.microsoft.com/t5/Flow-Ideas/Excel-Get-a-Cell-and-Set-a-Cell/idi-p/21931
Best Regards,
#1
David_MA
274
Super User 2025 Season 1
#2
Michael E. Gernaey
234
Super User 2025 Season 1
#3
stampcoin
210
Share
Report
All responses (
Answers (