Click button activity

Help
1

I am trying to link a Windows Form to a reconciliation system for the user to upload files.
I used Open Application to open the form and Click Button to select a button “Upload” but I cannot link it to the activity Select File to open a dialog box.

Can anyone help me please?

Button
Button2180×1037 355 KB

2

@Feryial Can you share the screenshot after clicking upload button what is the ui

3

@indra
The uploaded file (an excel) should go in a datatable.

Here is my xaml and window form:

ReadingExcel copy 2.zip (13.5 KB) Windows Form.zip (72.7 KB)

4

@Feryial As of now studio access is not available so can you share the screenshot so it helps others also to provide solution

5

@indra

I need to ask the user to upload files and the system needs to compare the data and output matched/unmatched files

Button
Button2180×1037 355 KB

27
272177×1041 230 KB

21
212161×1012 212 KB

28
282168×1011 296 KB

36
362175×1028 215 KB

6

@Feryial If you click upload button I guess it allows to upload file there you can use type into activity or if user wants to upload the file than you can use select activity

7

@Feryial What are the errors that you encounter? :sweat_smile:

8

@supermanPunch
I used “Click Trigger” activity and it is now working thanks.
I am trying to read a textile and put it in a database using “Generate Datatable”.
My column are separated by spaces only. Can you help me on this?

text file:

03
031880×270 135 KB

xaml:

23
232175×988 375 KB

9

@Feryial Can you send the Text File?

10

I included it as picture in the previous reply as I cannot upload text file here.

03
031880×270 135 KB

11

@Feryial If I need to work on the genearating dataTable part, I’ll be needing the File :sweat_smile: Are you Sure you can’t Upload the file?

12

Here you go I zipped it. Thanks a lot.

Incoming.zip (463 Bytes)

13

@Feryial Can you tell us the Total Number of Columns? :sweat_smile: There’s a bit of Confusion to identify the columns in text file

14

There are 23 columns.

15

@Feryial Sorry For the late reply, but this looks a little complicated, I am trying to achieve this using Regex method but i need some clarifications on the data in the fields :sweat_smile: If you already got a solution Please Share it

16

Yes I will share it if I can solve it thanks

17

@Feryial Can you tell me the maximum length of each Column , If the maximum length is sure , then i have a solution

18

I think it could be 20

19

@Feryial Alright I’ll send the workflow Once i finish the whole thing

20

Thank you so much!!