Excel row transfer to other excel file with Flow add-in (drop-down list)

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3135179%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EExcel%20row%20transfer%20to%20other%20excel%20file%20with%20Flow%20add-in%20(drop-down%20list)%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3135179%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHello%20guys%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20have%20an%20issue%20with%20he%20flow%20that%20is%20supposed%20to%20copy%20data%20from%20one%20excel%20to%20another.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20have%20created%20the%20flow%20within%20the%20excel%20file%20(flow%20add-in)%20and%20it%20works%20perfectly%20if%20the%20data%20are%20in%20%22typical%22%20shells.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EWhen%20I%20want%20to%20copy%20data%20that%20are%20put%20by%20drop-down%20list%20in%20excel%20it%20is%20not%20working%20(no%20data%20appear%20in%20the%20target%20file).%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ECan%20you%20help%20me%20with%20this%20issue%2C%20what%20can%20I%20do%20to%20move%20data%20that%20are%20put%20by%20drop-down%20list%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EMaybe%20there%20is%20some%20other%2C%20easy%20way%20to%20move%20particular%20data%20to%20other%20file%20(besides%20copying%20%3B)%26lt%3B%5C%2Fimg%26gt%3B%20)%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ETarget%20file%20(empty%20shell%2C%20numer%20wan%20not%20copied)%3A%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346134iCEEA4461639EB530%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22destination.JPG%22%20alt%3D%22%5C%26quot%3Bdestination.JPG%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ESource%20file%20(number%20is%20present)%3A%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346137i670F0BFCDF9D31AE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22source.JPG%22%20alt%3D%22%5C%26quot%3Bsource.JPG%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ERegards%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EMateusz%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3135179%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EMacros%20and%20VBA%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EOffice%20365%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Contributor

Hello guys,

I have an issue with he flow that is supposed to copy data from one excel to another.

I have created the flow within the excel file (flow add-in) and it works perfectly if the data are in "typical" shells.

When I want to copy data that are put by drop-down list in excel it is not working (no data appear in the target file).

 

Can you help me with this issue, what can I do to move data that are put by drop-down list?

 

Maybe there is some other, easy way to move particular data to other file (besides copying )

 

Target file (empty shell, numer wan not copied):

destination.JPG

Source file (number is present):

source.JPG

 

Regards,

Mateusz

 

2 Replies

@ocin33 

IMHO, flow shall not care how value appeared in the cell - by formula, from drop-down list or entered manually. What could be critical that column names and data types. I'd check flow step by step first.

@Sergei Baklan
Flow is really simple there, and it works because other values are transferred (but they are not in drop down). That is strange