User Interface App to Update an Existing Excel File

[CPAul]

I have little experience with the user interface tools, but I was wondering if it would be possible to create an app that would allow users to enter data to update an existing excel file that's saved on a shared drive. If, for example, I had an excel file with three columns:

SSO

First Name

Last Name

I'd like the users to be able to run the app and be prompted to input their SSO, first name, and last name which would update on the first available row. So if two people ran the app at different times the results would be:

SSO	First Name	Last Name
24545	John	Smith
78741	Mary	Johnson

Thank you in advance for your help!

Paul

[Prometheus]

@CPAul I like to use the Numeric Up Down tool when giving the user the ability to enter any number. That way I can control the amount and type of characters they input (solely numbers with this tool). When it comes to giving people the ability to input their names, there are a lot of things that can go wrong if you use a Text Box interface tool. You can try to use an Error Message, but you might want to consider using a Drop Down tool that has a list of names on it. That way, at least a correctly formatted value will pass to your workflow.

[lwolfie]

I would use the list interface for the user to select their name from a list.  You can reference an independent file to populate the list.  Then when you output the data to the file, be sure to use the Append to Existing Sheet on the Output Options for the excel file.

An alternative solution would be to use microsoft lists and integrate it with PowerApps.  The resulting list could then be brought into Alteryx for any analysis that you need to complete.