I’m working on a proposal for one of our clients which considers a UiPath App for collecting some information and then submitting this as a new request. After that “approvers” will have a different view where they’ll see all their pending request to approve/reject.
The first approach they proposed was working with Microsoft Forms, and from there one of the requests was for them to be able to upload a spreadsheet with some data.
We want to build a “in-built” spreadsheet for them to input this data into the App/Data Entity and with this we’ll be able to perform some data validation before they submit the request in order to avoid that requests with errors are submitted.
Besides this in-built spreadsheet, they still want to be able to load an excel file in case there’s to many lines to input into the app.
I know this is possible and what I’d like to understand is if there’s a way without an additional robot for those records to get inserted into the same data entity that’s going to be connected to the in-built spreadsheet (this so the data validation can be performed during the user journey on the app) or if I’ll need to trigger a process after the user submit the xlsx file so a unattended robot on the background running on 1 of their VMs perform this action (getting the records from the xlsx to the data entity to be able to perform the data validation)?
Sorry for the long read and thank you for taking your time to respond or propose ideas
Hey @Sebastian_Crohare
It’s should be possible to upload an Excel file directly to Data Service using the File Uploader control, without needing a robot for the upload itself.
However, the App cannot read the file contents or perform validation on its own. To process and validate that Excel data, a robot is still required.
This process can be initiated from within the UiPath Apps application - for example, triggered from within the App after the user submits the file.
Yes, so that confirms my suspicion I guess. Without a robot I’ll just be able to upload the file as a whole, but I’m not going to be able to insert each line of the excel file as a new record in the data entity. For that I’ll need a robot to retrieve the uploaded file and with that robot insert each individual record into the corresponding entity.
Thanks for sharing those videos, they were informative
I’m not sure I’m following you, webapps as a outside feature from UiPath Apps? Like integrating this outside service into my UiPath App to perform this?
Sorry for taking long to respond. I think this could be it, but we are to far ahead on the project using Apps, but it looks promising for future designs. I’ll dig deeper into webapps.
