Is it possible to create a brand new excel file with the exact same name as the old one and have powerapps use it as a datasource?

[Syndicate_Admin]

Hello, I'm new in IT so this may be a simple fix but I have a question about an app I'm making. I get a CSV dump of a few different things, use a powershell script to combine them into a single XLSX, and then use power automate to make them into tables. This happens at an automated time every day, and the issue I'm faced with is that every time it has to create a new excel document due to the data changing daily, and since they are CSV dumps I cannot just update the spreadsheet easily, having to resort to the powershell script method. Is there a way for my tables in the app to refresh to this new document that overwrites the old one completely and deletes it out of the onedrive folder, or is that not possible due to them having different names (as in metadata, the actual filename is unchanged every time it is remade.) If there is a way to force the excel online connector to forcibly find a specifically-named file without it checking its properties I would love to know, as this would solve all of my problems.

[Syndicate_Admin]

Quick question, what app do I use with power query? Excel? I noticed the source community is Power BI, and I'm making a PowerApp because the people using it wont have access to Power BI due to licensing. 

[v-yingjl · Accepted solution]

Hi @Syndicate_Admin ,

Basically both Excel and Power BI have Power Query Editor, we suggest that you can try to use Power Query in Power BI which could provide more features and could interact with other products.

For licensing, Power BI Desktop is a free product for users when you are using it to transform data, create visuals etc on your pc, there should no license limitation. If you want to share this reports with others on Power BI Service, you may need a Pro license.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Ill try this and get back to you, thanks for the advice!

[Anonymous]

Seems like you could combine the Csv files and make them into tables with just Power Query. Add a little VBA that uses ThisWorkBook.RefreshAll, and use task scheduler to open it. Wouldn't that work?

--Nate