How to get data uploaded file in App

Help Apps
,
1

Hi…

User upload file in Uipath apps. the uploaded the excel file automattically tigger to run the xaml code…

how to get the value in excel data ?

Thanks
Shyam

2

@Shyam_Pragash do you mean, you want to extract the data from excel?

3

Hi @mosa_sleeman

yes… extract data to use in queue items for auto tigger purpose…

Thanks
Shyam

4

Hi!

You can achieve this by using app integration

Reference:

Regards,

5

Hi…

Any demo or use case

Thanks
Shyam

1 Like
6

You can do the same by read the excel “read range activity “ then take the output then you can add it via “Add queue item “ or “bulk queue item” activity

7

Hi!

Have a view on this>>

Regards,

1 Like
8

Hey @Shyam_Pragash

Could you please explain a bit more ?

Is it like, the user upload an excel file from the Apps and a bot picks it to process ?

Thanks
#nK

9

Hi @Nithinkrishna

Ur right…

on daily based user sent mail. i have tigger it mannually run the code (xmal) on daily.

use input:

image

i have get the data one by one paste to browser…

Apps

image
image1060×315 10 KB

if use uploaded the excel file bot tiggered to run main code.

Thanks
Shyam

1 Like
10

Hey @Shyam_Pragash

So there are 6 items in the excel all these are transaction items ?

Thanks
#nK

11

Hi @Nithinkrishna

i share little bit tranasaction items…

Thanks
Shyam

12

No @Shyam_Pragash

It’s fine, I want to just know if those are the transactions.

So you need to upload the file to the Storage Bucket by linking which is then processed !

Thanks
#nK

13

Hi @Nithinkrishna

i want to auto tigger the process if file is upload. Get data from the upload file for processing…

can you tell me how it possible ?

Thanks
Shyam

1 Like
14

Hey @Shyam_Pragash

You will need to have an event out there to start a process once the file upload is clicked.

That will help trigger the bot !

Hope that helps.

Thanks
#nK

15

Hi @Nithinkrishna

File uploaded successfully… and store it storage buckets…

but cant able tigger the process… from storage buckets.

Thanks
Shyam

1 Like
16

@Shyam_Pragash ,

I would suggest below approach to do. Impalement below rule as below.

  1. Add file into storage bucket.
  2. Start UI Path Process
  3. Pass Input Argument as file name into process to Identify file from storage bucket.
  4. In UI Path Process
    1. Read File from storage bucket based on file name
      2.You can add queue item or transaction whatever you needed to do into process.
  5. Complete the Apps

Thanks,
Ak

17

Hey @Shyam_Pragash

The process trigger should be from the app !

Through the events option !

Also, please show a snap of your app.

Hope that helps

Thanks
#nK