My Use Case:
First I need to read the excel file. The file contains three columns (InvoiceNo, VendorName, InvoiceAmount).Additionally, I’m adding another IsApproved column to the dataTable as boolean type. Then I’m passing the dataTable to UiPath Action App through Input property. In the UiPath Action App I using edit grid control to display the DataTable and changing the column of IsApproved to checkbox. After selecting the appropriate checkbox related to the row. I need to return the whole data including the IsApproved column from the action app and write it in a new excel file.
I’m my edit grid data Source to action app input property(where i’m passing the dataTable from studio).
My Issue:
I’m not able to update my checkbox in action app. Whenever I loose the focus the checkbox resets to default value.
Input properties are read-only by design.Any user edits must be written back to a local variable or Output-bound variable, otherwise the UI refreshes with original data.
So, Basically Edit Grid needs local variable binding, then Enable Update Data Source on Change, then Return updated data via Output property.
I’ve created a local app variable and create a rule in the event tab of the page. when the page is loaded. I’m saving the data source value to local app variable. when using the local app variable in the edit grid the values are not populating.
In UiPath Apps, we can only create variables; we cannot initialize them with a default value. Values can only be assigned during the Page Load event. Is there any other work around for this?
As you suggested, I tried the above approaches, but I couldn’t find a workable solution. I’m attaching my workflow and Action App—please review them and let me know how I can achieve this.
