Large list data source -
- I have seven large Excel spreadsheets (between 4,000 and 12,000 line items) that I'd like to use as a data source in Power Apps.
2. Each list represents a 'Region'. I get the lists emailed to me quarterly from another program.
The Power App would need to filter the data source by column 'Region', column, 'City' or column 'Location ID'.
What is the most efficient way to manage such data (Excel or SP List), recognizing that the same reports are provided every 90 days - and the data may or may not have been deleted, edited, or be new in the set.
Should the lists remain separated or combined? If SP is the preferred method how should the data be most efficiently and accurately imported into SP?