Multiple Spreadsheets - Return based on user

%3CLINGO-SUB%20id%3D%22lingo-sub-390633%22%20slang%3D%22en-US%22%3EMultiple%20Spreadsheets%20-%20Return%20based%20on%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390633%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20a%20excel%20spreadsheet%20that%20users%20have%20a%20copy%20of.%20I%20have%20PowerApps%20connecting%20to%20one%20document%20and%20can%20update%20and%20edit%20the%20document%20which%20is%20really%20great.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EIs%20there%20a%20way%20I%20can%20return%20a%20spreadsheet%20depending%20on%20the%20user%20so%20they%20only%20get%20their%20data%3F%20Can%20the%20app%20connect%20to%20multiple%20excel%20documents%20and%20return%20based%20on%20the%20user%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-390633%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-390700%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Spreadsheets%20-%20Return%20based%20on%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390700%22%20slang%3D%22en-US%22%3E%3CP%3EWhew%20was%20worried%20about%20that%20one.%26nbsp%3B%20I%20see%20so%20many%20people%20using%20excel%20as%20a%20data%20source%20rather%20than%20was%20the%20tool%20was%20made%20for.%26nbsp%3B%20%3CSTRONG%3EI%20agree%20I%20can%20take%20fly's%20out%20of%20the%20house%20with%20a%20shotgun%20however%3C%2FSTRONG%3E.%26nbsp%3B%20Use%20the%20proper%20tool%20for%20the%20proper%20job.%26nbsp%3B%20Access%20is%20not%20that%20hard%20(but%20it%20costs)%20MySQL%2C%20Xbase%20both%20free%20tools%20(yes%20I%20am%20that%20cheep).%26nbsp%3B%20Odbc%20is%20your%20friend%20learn%20how%20to%20run%20a%20query.%26nbsp%3B%20Excel%20is%20great%20for%20reports%20and%20populating%20from%20querys%2C%20and%20it%20works%20great%20from%20powershell%20and%20other%20scripts.%3C%2FP%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F110461%22%20target%3D%22_blank%22%3E%40David%20Gorman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-390698%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Spreadsheets%20-%20Return%20based%20on%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390698%22%20slang%3D%22en-US%22%3E%3CP%3EThank%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F309886%22%20target%3D%22_blank%22%3E%40Robert_Golobek%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20trying%20to%20get%20them%20to%20move%20to%20an%20actual%20database%20for%20this%20for%20a%20while%20but%20just%20wanted%20to%20play%20with%20PowerApps%20and%20see%20what%20was%20possible.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-390696%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Spreadsheets%20-%20Return%20based%20on%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390696%22%20slang%3D%22en-US%22%3E%3CP%3EOne%20thing%20I%20can%20think%20of%20is%20putting%20a%20wrapper%20on%20that%20excel.%26nbsp%3B%20Powershell%20script%20grab%20users%20info%20open%20excel%20copy%20from%20remote%20sheets%20populate%20local%20form.%26nbsp%3B%20On%20exit%20move%20data%20back%20to%20source.%26nbsp%3B%20If%20exit%20inproperly%20edits%20will%20be%20(cashed%20locally)%20if%20reopen%20cash%20destroyed...%20Contact%20admin%20to%20repair.%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20many%20users%20and%20how%20much%20trouble.%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20method%20I%20would%20think%20about%20populating%20the%20user%20info%20using%20sql%20and%20MySQL%20or%20an%20Xbase%20table%20run%20query%20from%20within%20excel%20and%20update%20tables%20from%20sheets%20have%20master%20query%20and%20update%20on%20a%20cycle.%26nbsp%3B%20Then%20there%20is%20that%20other%20method....%20How%20deep%20you%20want%20to%20go%3F%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F110461%22%20target%3D%22_blank%22%3E%40David%20Gorman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Contributor

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 return a spreadsheet depending on the user so they only get their data? Can the app connect to multiple excel documents and return based on the user?

3 Replies

One thing I can think of is putting a wrapper on that excel.  Powershell script grab users info open excel copy from remote sheets populate local form.  On exit move data back to source.  If exit inproperly edits will be (cashed locally) if reopen cash destroyed... Contact admin to repair. 

How many users and how much trouble. 

Another method I would think about populating the user info using sql and MySQL or an Xbase table run query from within excel and update tables from sheets have master query and update on a cycle.  Then there is that other method.... How deep you want to go?

@David Gorman 

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.

 @David Gorman