Forum Discussion
Multiple Spreadsheets - Return based on user
Hi all, We have a excel spreadsheet that users have a copy of. I have PowerApps connecting to one document and can update and edit the document which is really great. Is there a way I can retu...
Thank Robert_Golobek
I've been trying to get them to move to an actual database for this for a while but just wanted to play with PowerApps and see what was possible.
Whew was worried about that one. I see so many people using excel as a data source rather than was the tool was made for. I agree I can take fly's out of the house with a shotgun however. Use the proper tool for the proper job. Access is not that hard (but it costs) MySQL, Xbase both free tools (yes I am that cheep). Odbc is your friend learn how to run a query. Excel is great for reports and populating from querys, and it works great from powershell and other scripts.