
Announcements
I would like to know if and how to create a database in power apps that can pull specific rows and columns from all excel spreadsheets inside of a folder (they would all have the data in the exact same columns and rows to pull from).
For the exact use it goes like this:
We have devices that get sent out for repair. When we do this, we have to follow an excel spreadsheet to put the data on and print out for that company. When we get these devices back, we have to go through each and every spreadsheet to mark the return date of the device as some devices come back and will be from many excel sheets ago. I would like to be able to have a database pull the information from these excel spreadsheets (as all the information is in the same columns and rows, never changing), then be able to just search in the database for the item and mark it as returned based on whatever day it is. This would make our process much easier and manageable.