RPA Challenge data

Help Studio
1

Hi! I’m trying to run the RPA challenge on UiPath and I can’t get the phone numbers from my excel sheet to input into the website. I keep getting an error message that it can’t convert to String. I have tried changing the variable type and I still cant seem to get it to run. Any ideas??

2

Hi @Katherine_Ward

Welcome to the UiPath Forum Community

Can you please share the screenshot of the error message and if possible of the workflow also.

3

IMG-4082
IMG-40821512×2016 1.37 MB

This is what the error message looks like.

4

Check this xaml file

phone number.xaml (8.7 KB)

5

Still pretty confused…Any other ideas?

6

Could you please show the full expression in your activity and when the error occurs. Should not be an issue to change double to string…

Also, instead of using “Get Row Item” Activity you could use “Read Range” to read source table and then use a “For each Row”-Loop where you assign / type row(“Phone Number”).ToString .

Otherwise please share more details :wink:

1 Like
7

Automation 2_RPA Challenge Handout.pdf (1.9 MB)
This is the handout I used. I walked through all the steps so my work flow looks the same. If this still does not help I can take picture of my workflow.

8

Please send pictures

9

IMG-4084
IMG-40844032×3024 2.37 MB

IMG-4085
IMG-40852016×1512 1.06 MB

IMG-4086
IMG-40861512×2016 911 KB

IMG-4087
IMG-40871512×2016 1.07 MB

IMG-4088
IMG-40881512×2016 959 KB

10

Hi @Katherine_Ward
can u show thw variable type of PhoneNumber?

11

IMG-4090
IMG-40903024×4032 3.72 MB

12

Can u change the PhoneNumber variable to Double instead of String?

13

Following Options:

  • Try checking “PreserveFormat” Property in the read range activity
  • If not working you can change the variable type of PhoneNumber to Generic Value (or double as mentioned by @NIVED_NAMBIAR ) :wink:
14

IMG-4094
IMG-40942016×1512 1.06 MB

This is the new error I’m getting. This is after I checked the “PreserveFormat” property in the read range activity.

15

I get the error “option strict on disallows implicit conversions from ‘Double to String’.”

16

Hi @Katherine_Ward instead of row(PhoneNumber) use PhoneNumber.ToString in Type into

17

That fixed it. Thank you so much!!!

1 Like
18

@Katherine_Ward
The screenshots are quite not much clear.
any way u can try this
Use an assign activity
ph_no=row.Item(“PhoneNumber”).ToString
declare the variable -Ph_no in variables panel

19

Hi @Katherine_Ward
kindly mark the appropriate answer as solution so that we can close the topic

20

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.