Still quite a newbie using UiPath, trying a project with 3 flow decisions, but got some errors, can someone help me, thanks
Step 1
Read range from Gsheet > For each row > If row.IsNull(5)
**This step seems working, but how to loop back to beginning when False (Else) ?
Step 2
Lookup Data Table to check whether “subDom” is duplicated or not > If dt.Columns.Contains(subDom) IsDuplicate=True >
Then Send Mail Message
**How to get email of Recipient from the correct cell on Gsheet ?
Else Write Cell
**How to write to the correct cell on Gsheet ?
Step 3
Open Browser to do some actions
**How to loop back when all the actions after Open Browser are completed ?
Fine
No worries
—first step of read range is fine
—getting output from the previous step with a datatable named dt and passing it to a for each row loop is fine
—inside the loop using if condition should be like this
String.IsNullOrEmpty(row(5).ToString)
If true it will go to THEN part where we can have any process we want or if it’s false it will go to ELSE part where where we can keep it empty so that it will loop again back to the next row in the datatable as it is still in the for each row loop which answers this question
—now coming to the point
Kindly elaborate the process we want o carry out from lookup datatable and why do we use datatable and what we are going to do after that and with its result
Cheers @MubieSam_Lin
@Palaniyappan Thanks for the quick reply.
The step 2 is for checking whether “subDom” is duplicated or not.
There is a column titled “sub Domain”, need to check whether “subDom” is duplicated with existing “sub Domain” of other rows or not.
If True (IsDuplicated), Then Send Mail Message to ask user to choose another “sub Domain”.
If False (Not duplicated), Else Write Cell to indicate the row is OK to proceed next action Open Browser, meanwhile, it also add “OK” to row(5) to be not NullOrEmpty in step 1.
Questions
- Is the flowchart correct for this purpose?
- How to get email of Recipient from the correct cell on Gsheet ?
- How to write to the correct cell on Gsheet ?
- How to loop back when all the actions after Open Browser are completed ?
@Palaniyappan Tried to follow your reply on How To send outlook email including the name from an excel DataTable as the body - #2 by venkatmalla6
But got an error “Not all generic types could be resolved.” when “create a list variable named outlist in the variable panel of type system.collections.generic.list(of string)”
I’m using Send Mail Message of GSuite instead of Outlook, will that be the problem?
Thanks