Hi @Dushy,
According to your description, do you want to store a record extract from a data source into an Excel file stored in OneDrive? If I misunderstood, please kindly let me know.
If so, you could use the Add a Row into a table action of Excel connector to approach that, here is the document for reference to :
Excel Online (Business) - Connectors | Microsoft Docs
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.