Announcements
Hello,
While I'm trying to use a property as a value of a DataTable (made by DataTable action), I'm getting the below error.
Actions
DateColumn's value returns 1 at first action.
Error Message
Any advice please? Thanks in advance.
Can you make sure that DateColumn -variable is Numberic value:
not Text value
If it is Text value then use Convert text to number -action and name the produced variable DateColumn and try again. This is because if you add text value to the column then it should be the columns name. If it is numerical value then it is the index as with your case I assume.
Hi @pkour ,
Please find the solution.
As per my understanding,You cant call the Column in DataTable as you have done.Alternatively you can try as below.
Code:
Variables.RetrieveDataTableColumnIntoList DataTable: ExcelData ColumnNameOrIndex: $'''Value''' ColumnAsList=> ColumnAsList SET DateColumn TO ColumnAsList[0]
(Note:- if you got your solution you can mark as solution and gives kudos)
Thanks & Regards
Vishnu Reddy
Both of them combined and returned the correct value.
@eetuRobo @VishnuReddy1997
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 474
11manish 268
David_MA 243 Super User 2026 Season 1
