If you need help, post a question as a reply in the Forum discussion below. To increase your chances of being helped, be as descriptive as possible. Include in your comment:
- A description of your issue: when is it happening, what activity you have trouble with.
- A screenshot of your error.
- You can also attach your automation project.
If you can help a fellow learner, don’t be afraid to reply and make a suggestion. Participating in the conversation helps solidify the knowledge you’ve acquired in this course.
1 Like
Hi UiPath Community 
,
I’m currently working on an exercise using UiPath Studio Web with Autopilot, and I need help validating codes from a Google Sheets file and sending conditional emails based on the format.
Goal:
Read each row from a Google Sheets file (customer_codes_with_emails) and check the “Code Submitted” column.
If the code:
Matches this format: PRD-1234AB (starts with PRD-, 4 digits, and 2 uppercase letters)
→ Send email with subject: “Registration Successful”- Doesn’t match the format
→ Send email with subject: “Action Needed: Invalid Code”
Questions / Help Needed:
- Is my Autopilot prompt correct to generate this flow end-to-end?
- What’s the best way to validate the code format in Autopilot (do I use Regex inside Studio Web)?
- How can I preview or test the flow to confirm the email logic works?
I’ve already connected my Google account and can access the Google Sheet.
Thanks in advance for your support—I’m really enjoying working with Autopilot! 
— Roopa Patel
Unable to select the birthday month in the Select Item activity via using varible. If we select from the drop-down menu, it works, but if we use a variable, it auto-corrects and shows null. Please find the screenshot.
-
In my case, the flow autopilot can generate content based on
input prompt, but it may also produce some errors. After the flow is generated, it is our responsibility to validate it.
-
We can create regular expressions using the autopilot feature in the VB Expression Editor. Simply provide the requirements and request the generation of the regular expression in natural language within the autopilot box. If there are any errors in the expression, we can fix them using the “Fix” option in the VB Expression Editor.
-
Yes, you can test the expression within the VB Expression Editor.
ValidateCodeAndSendEmail_Final.uip (23.9 KB)
Product is aware of this, and the bug will be fixed soon. Thank you!
1 Like
Hi, in the generative AI exercise, Studio Web is not able to recognize the categorize_create type. I can’t continue my exercise.
Could you please help me?
Thanks,
Caterina
1 Like
For people who are using personal account to do the academy course:
Issue: Unable to create the Microsoft Onedrive and Sharepoint Integration Service connector to complete the GenAI module in Studio Web course.
Snapshot:
Possible Root cause: SharePoint is meant for business use, therefore all personal account won’t have access to it.
My Solution: I replaced the Get file or folder - 365 activity with Google Workspace activity and uploaded the file in drive to continue with the course.
Please keep in mind, if you are following this approach then you will have to replace every activity with the Google Workspace activity.
My suggestion is to revise the course - Get Started with UiPath Studio Web to allow the developers to switch the Google Workspace activities since I believe this SharePoint integration service issue will be faced by a lot of us.
P.S: If anyone has found an alternative solution, please let me know.
1 Like
Hi there,
try this regex:
“^\s*[”“']?PRD[-\p{Pd}]\d{4}[A-Z]{2}[”“']?\s*$”
I have the same case. Decided to upgrade my M365 account to business line and it works.
I am going through the exercise with the Semantic Similarity. I am confused why you have the Semantic Similarity capturing the Similarith within a For Loop for each row of the respective workbook? You then have the If SimilarityScore.value >= 0.2 outside the For Loop - so, won’t it ONLY ever capture the similarity of just the last line within the respective tab of the userfeedback Excel sheet?
For example, there are seven bugs listed on the “Bug report” tab. The example code iterates through each row comparing the email’s summary to each description - generating a Similarity Score for each row. Then it exits and checks if the score is >= 0.2. In that manner won’t it only ever capture the last bug’s similarity?
Thank you!
Rob
