I hope you can help me or is able to point me in the right direction, because I dont know where to begin or if this is even possible using Microsoft Flow.
I have a customer who receives generic Excel sheets from different customers. The excel sheets contains different Data, - Prices, ProductionNumbers, Names...
The picture below demonstrates the Excel data received from multiple sources and merged into one.
Thanks in advance and I appreciate your time and help!
hi @farfan if ProdName, Size, PriceA, Price B, Price C and allways the same you can merge the data as your example. if not you can just merge all information in one excel table like
|ProdName(C1)||Size(C1)||PriceA(C1)||Price B(C1)||ProdName(C2)||Size(C2)||PriceA(C2)||Price B(C3)|
The shure you can use an api to do whatever the api does.
Thank you for the respons. I am glad for hear that it is possible.
It is not always the same data that is being injected.
I am very new to Microsoft Flow, - Have only build 2 other flows.
How do I get started building this specific flow, any recommendations? or are you able to give me a Flow Outline / Point me in the right direction on where to start?
@farfan shure you need use list rows present in a table (Excel) create 3 to all of your excel files. Then you need to create a excel dile with a table an the headers of the data you want to populate. Then in your flow create an action called add row into table then select the previus excel created and you are goint to see your columns, and just in dynamic content select the columns corresponding to the data you want to populate.