How to get Last updated Entry from Web Application Table

I want to get the last updated Entry from Web application. Can anyone please advice.

Below is the screen shot of table. from there I just want to fetch the data like.
ActualApprover - Nilesh Mahajan
PendingStartDate - 2021/04/19 14:18:55

Do a regular data scraping an then, e.g:

Assign:

MyLastUpdatedDataRow = ExtractedData.AsEnumerable().OrderBy(Function(myRow) DateTime.Parse(myRow("PendingStartDate").ToString)).Last()

MyLastUpdatedDataRow will be the last updated entry in your data table.

Hello Alex,
thnx for reply.
I have tried this, but is throws the error saying “Assign: Column ‘PendingStartDate’ does not belong to table .”
Even If the table name is present there.
Below is the screen shot of Exctracted Data Table using Data scrapping.

The data scraping didn’t recognized your column names.

Your headers are in the first row.

So, myRow("PendingStartDate") is actually myRow("Column-6")

Remove the first row and use the Column-x names instead or promote the first row as headers.

I wrote an set of activities that can help you on that:

I have used this statement in assign activity as per you advice in column header -
ExtractDataTable.AsEnumerable().OrderBy(Function(myRow) DateTime.Parse(myRow(“Column-6”).ToString)).Last().ToString

but getting below error -
Assign: The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.

Hi @nilesh.mahajan

Did you removed the first data table row before using the statement? Otherwise the statement will try to convert “PendingStartDate” string to DateTime which will fail.

First, add a remove data row:
image

Remove the first row: index 0

Then, try use the statement.

Note: If you can have empty values in this column, the DateTime conversion will also fail. I’m assuming that you will always have a valid date in this column.

I have tried as per you guide. But some bad luck.
I think data is not is correct format. thats why now its give me output.

image

I am trying yo get Approver Name and PendingStartDate from this table.

attached is the extracted Data in Excel file which is not in standard format.
Test.xlsx (7.5 KB)

Hi @nilesh.mahajan

The statement returns the DataRow, not value in the cell.

You need get the values that you need specifying which columns you want.

I attached the solution:

Main.xaml (7.4 KB)

Please, note that I use “Column6”, “Column3” in the code and not “Column-6” or “Column-3” because I’m reading from the Excel and the column names behavior differs from yours.

Change that and I think it will work for you.

Yes it’s work fine for me now, solved my challange

1 Like

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