Hello everyone,
Learning Plan: RPA Citizen Developer
Course: Decisions, Iterations and Scenarios in UIPath Studio X
Class: Decisions
Tool: UIPath Studio 2021.12.0-beta.7179 Community License Per-User Installation
Goal: I want to make a comparison - if the excel Transaction # cell is empty, the fields get the text of DoubleUI app , else it writes on the comments excel cell.
Problem: I’m not being able to use the “isEmpty” functionality on the IF decision;
Description: I’m not being able to use the same expression of the video of the course. When I’m doing the comparisons, I always get an error.
Usually, is this one “isEmpty is not a member of UiPath.Excel.ExcelValue”.
I’ve tried:
- CurrentRow.ByField(“Transaction #”).isEmpty()
- CurrentRow.ByField(“Transaction #”).isNull()
- CurrentRow.ByField(“Transaction #”).isNullOrEmpty()
- CurrentRow.ByField(“Transaction #”).isNull() == true;
- CurrentRow.ByField(“Transaction #”).isNull() == 0;
- CurrentRow.ByField(“Transaction #”).isNullOrEmpty() == true;
- CurrentRow.ByField(“Transaction #”).isNullOrEmpty() == 0;
- CurrentRow.ByField(“Transaction #”) is empty → This one gets another error: " System.Empty is not accessible in this context because it is Friend"
File: Easyupload.io - Upload files for free and transfer big files easily. → I have to use an external source because I’m a new member and I can’t upload files here.
File Password: “MeuCu”
I’ve been checking the following topics, but nothing is working on my side:
- /t/what-is-the-function-for-is-null-or-not-null/77643
- /t/how-do-i-know-if-a-cell-is-empty/6330/11
- /t/if-excel-is-empty-robot-doesnt-read-cell/265605
- /t/if-string-variable-is-blank-then-do-something-else-via-if-activity/123668/2
I really appreciate your time! Thanks in advance!