Hi, I have a CSV file that I can save/place on an FTP Server, eventually this will be accessed by a Magento 2 website and used to update stock levels.
The file is pretty simple, just two columns, SKU and Quantity (Quantity in Stock), but here's my issue. Magento 2 doesn't know what to do with stock levels that are not numbers, and some of my suppliers send through the info with words in the stock level feed like "none" or "not available", so I need Power Automate to look at this column and change anything thats not a number into a number, this could be done with lots of different "Find and Replace" type actions, if this is possible, that I could build individually.
Once the changes have been made then I just need it saved and Magento will read it from there.
I am a complete newbie and was just wondering if Power Automate was capable of doing this? Is it easy enough to build a flow for this? Any help would be greatly appreciated.
Thanks,
Neil.
Hi, @NAMCKNIGHT, to answer your questions directly:
😉
If you wanted some more specific help with a flow, I would say a good place to start would be:
For example, are the numbers (when there are no words) in the CSV within quotes, or are they just the number? Not all CSV files are made the same. 👍
A CSV could look like any of the examples in the below spoiler (but often the first):
If it's the first example, then the below VERY SPECIFIC Select action will work.
That is until an SKU gets a comma in it, or more columns start to be returned. But I would not recommend you trying this without a little more time under your belt ... or by browsing the forum a little bit. I think I've answered the question you're asking (there or there abouts) recently elsewhere. 🙂
You need to have defined a string variable called carriageVAR that simply has a new line in it (press ENTER once), and those expressions must be entered into the expression editor.
As you may realise, a lot of this is quite advanced, and even then it can break. It's possible to make it sway to anything, but it gets more complex.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2