I'm seeking advice on optimizing a Power Apps flow for updating stock quantities on my ecommerce site. Here's the challenge:
- Data Source: I download a tab-delimited file via FTP from my supplier, containing around 350,000 SKUs.
- Current Flow:
- Download: Successfully download the file using Power Apps.
- Parse: Attempt to parse the 350,000 SKUs.
- Extract: Retrieve the 250 SKUs relevant to my site.
- Update: Update the stock quantities on my ecommerce site.
- Issue: The flow times out during parsing, making it inefficient.
I need guidance on architecting this solution more effectively. How can I efficiently process such a large file and update only the relevant SKUs on my site without timing out? Any insights or recommended practices would be greatly appreciated.
Thanks in advance!