You’re offline. This is a read only version of the page.
Announcements
Hi All! I have a pricelist in excel format. Filename "DRAGONWAR-PRICELIST.xlsx" (image of data sample below)
I save it to my onedrive into /root/DRAGONWAR/ folder.
I want to create a power automate flow to:
1) TRIGGER when I have updated the DRAGONWAR-PRICELIST.xlsx file in /root/DRAGONWAR/ folder in onedrive.
2) copy the same excel spreadsheet data to 3 new files;
"DRAGONWAR-PRICELIST-HQ.xlsx" in /root/DRAGONWAR/HQ/ folder,
"DRAGONWAR-PRICELIST-MQ.xlsx" in /root/DRAGONWAR/MQ/ folder, and
"DRAGONWAR-PRICELIST-LQ.xlsx" in /root/DRAGONWAR/LQ/ folder
3) Perform calculation on "COST PRICE ex TAX" column in those three files folders (LQ, MQ, HQ),
LQ - I want to increase cost price ex tax column pricing by 16%
MQ - I want to increase cost price ex tax column pricing by 12%
HQ - I want to increase cost price ex tax column pricing by 8%
4) lastly, take those updated files and email all three of them to me.
I'm struggling to understand how I take the data in a column and update with formula in excel file online with flow. Any suggestions?
DATA SAMPLE
Hi @chrismensforth ,
At present, actions in the Excel connector can only operate on data in the Excel table, so these data need to be stored in a defined table before we can operate on them.
Please check the document and get more details about excel connector:
https://docs.microsoft.com/en-gb/connectors/excelonline/
Besides, Excel formula is not supported in Power Automate, we cannot configure formula in Flow and apply it to the Excel table.
Best Regards,
Share
Report
All responses (
Answers (
522
