Lookup Data Table UiPath | Lookup Data Table UiPath Example | Lookup Data Table Activity in UiPath

🔥 Subscribe for uipath tutorial videos
: This video explains about Lookup Data Table activity in UiPath.
#uipath #rpa #uipathexpohub #roboticprocessautomation #automation *****
Dear Learners, I need your support too!
Please Subscribe to my channel and show your kind support!
Link to UiPath Beginners Playlist:
• UiPath Tutorial | Uipa...
Link to UiPath Excel and DataTable Playlist:
• UiPath Tutorial | Buil...
Link to UiPath Key Technique Playlist:
• Move File Uipath | Uip...
Link to UiPath Email Automation Playlist:
• UiPath Tutorial | Uipa...
Link to UiPath PDF Automation Playlist:
• UiPath Tutorial | Uipa...
Link to UiPath ReFramework Playlist:
• UiPath Tutorial | Uipa...
Link to UiPath Classic and Modern Excel Activities Playlist:
• UiPath Tutorial | UiPa...
Link to UiPath Regular Expression Playlist:
• Uipath Regex
Link to UiPath Orchestrator Playlist:
• Uipath Orchestrator Ho...
Link to Advance UiPath Orchestrator Playlist:
• How to Use Storage Buc...
Link to UiPath VB dot Net PlayList:
• UiPath VB.Net Complete...
Link to UiPath Use Case Playlist:
• UiPath Birthday Remind...
Link to UiPath Selectors Playlist:
• UiPath Introduction to...
Link to UiPath Enhanced Selectors Playlist:
• UIPath Enhanced Select...
Link to UiPath Computer Vision Playlist:
• Learn UiPath Computer ...
Link to UiPath Interview Series Playlist:
• UiPath Interview Quest...
Link to UiPath Document Undestanding Playlist:
• UiPath Document Unders...
Link to UiPath Action Center Playlist:
• UiPath Action Center i...
Link to UiPath Error and Fix Playlist:
• UiPath Error Message#1...
Link to UiPath Activities Playlist:
• Parallel For Each in U...
Link to UiPath Certification Playlist:
• UiPath DataTable Selec...
Link to UiPath Background Automation Playlist:
• Background Process Aut...
Link to UiPath Logs Playlist:
• UiPath Logs | UiPath L...
Link to UiPath GitHub Integration Playlist:
• How to Create a GitHub...
Link to UiPath API Integration Playlist:
• API | API in UiPath |...
Link to Python Playlist:
• How to Create a GitHub...

[@MYWORLD-xp2pp]

Thank you brother🙌

[@Steve-yq5fh]

11:45 was the exact problem I had been encountering.
Thank you!!!

[@AutomatewithRakesh]

You are welcome Steve

[@Steve-yq5fh]

@@AutomatewithRakesh Using the variable type ‘System.Double’ also worked for me.

[@waldemarzielinski6958]

very good exemple ! thank you

[@AutomatewithRakesh]

Thank you!

[@alfredpereira9152]

Thank you!

[@AutomatewithRakesh]

Most welcome Alfred

[@bhupendra6789]

Hello Sir, What if there is duplicate entry in the excel file. In same example if there are 2 persons of same name and different location. How can we get lookup for same name that is present twice in name column.

[@kelip182]

Thanks for the demo Rakesh. Nice one.
Can I ask how can we make the user's input more robust? for example, user may type in name as 'm'ichael (1st letter lowercase) instead of 'M'ichael. the lookup data table is unable to detect 'm'ichael hence message box is printing nothing. I tried to do 'userInput=userInput.ToUpper' but the whole name will be uppercase instead of just the 1st letter in the name.

[@Steve-yq5fh]

Hi
You have a few options.
Option 1: You could check the input if they have any characters that are not A-Z. Then ask the user to double check it?
Option 2: You could filter out any characters that are not letters.
Try this syntax with an Assign Activity:
System.Text.RegularExpressions.Regex.Replace(INSERTVARIABLE, “[^a-z A-Z]”, “”)
This will replace any characters that are not A-Z with nothing ("").
Cheers