How to always get the value of last column ?

(0) Share

Report

Posted on by RookAils1

136

Greeting,

I have several datatables where I extracted from a PDF and each line kinda look like this. So, I would like to get the value of the last column. In this case, Column3. Sometimes, the Row could have 2 or more columns but the last column always contain the value I want,

Would appreciate any help or suggestion on this matter.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Sort by

CU16071609-1 6,255 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

@RookAils1

Give this a try:
To retrieve the number of columns from your DataTable, use `DataTable.Columns.Count`. Then, during the iteration of your DataTable using a foreach loop, you can refer to `currentItem[DataTable.Columns.Count-1]`. This will consistently return the last value of your DataRow.

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@RookAils1
Have you attempted the provided solution? Feel free to reach out if you have any questions about it.

If the solution proves effective, kindly consider marking it as the accepted answer. This will assist others in finding the solution easily through search.

Was this reply helpful? Yes No
RookAils1 136 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the suggestion provided. Im making progress towards it. I have a new inquiry, if I may ask, based on the screenshot I provided above, how should I combine the value form Column1 and Column2, in this case it will become "Invoice No: "

Could you assist me on this @Deenuji ?

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@RookAils1
Try something like below:
CurrentItem[ExcelData.Columns.Count - 2] + CurrentItem[ExcelData.Columns.Count - 1]

Code:
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\deenu\\OneDrive\\Documents\\Invoice_Details.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: False RangeValue=> ExcelData
LOOP FOREACH CurrentItem IN ExcelData
Display.ShowMessageDialog.ShowMessage Title: $'''Alert''' Message: CurrentItem[ExcelData.Columns.Count - 2] + CurrentItem[ExcelData.Columns.Count - 1] Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
END

Was this reply helpful? Yes No