Hi,
I have a question on PowerApps DataSource. An excel file will be download and to be stored in a SharePoint maybe on a weekly or daily basis. This excel file is from a web source where i can pull data for the last three years and whenever a new row record gets added in the Website and if i download and connect it has to be shown in my powerApps.
The excel file that i download will have data up to date and anything before 3 years will get removed in the downloaded file. I need to maintain the powerApp in a way like only newly added records from my excel file needs to be updated and the previously added should not be removed.
Is there a way to do this?