Unanswered

Read grid data in desktop application - urgent

(0) Share

Report

Posted on by Panuragagra

i am trying to read "Claims Status" column value from the below grid.. like "Rejected", "Ready" etc. and based on that i will loop through.

i am reading data like this ,

Data is coming like this..

How do i extract "Claims Status" column value which is Rejected and store in variable to loop through ?

Appreciate it ..thanks,

Categories:

Power Automate Desktop

I have the same question (0)

All responses (9)

Answers (0)

Sort by

davidengel 6 on at

Like
a
(0)

Report
Copy link

Link copied!

It looks like the data is coming back as a data table. If that's the case, you should be able to iterate through the data rows with loops.

Was this reply helpful? Yes No
Panuragagra 50 on at

Like
a
(0)

Report
Copy link

Link copied!

I am trying to store output into a list so i can extract data..what am i doing wrong ? see the above screenshot and error. Appreciate your help.

Was this reply helpful? Yes No
Gidi 601 on at

Like
a
(1)

Report
Copy link

Link copied!

Can you check the data type of RTSDatafromWindow? Maybe it’s already a list or a multiline string.

Was this reply helpful? Yes No
Panuragagra 50 on at

Like
a
(0)

Report
Copy link

Link copied!

I thought , i will copy RTSDatafromWindow to list Claimsstatusvalue, then iterate by Claimsstatusvalue[index]..i am doing something wrong

then i got this error...

Was this reply helpful? Yes No
Gidi 601 on at

Like
a
(0)

Report
Copy link

Link copied!

Well, the error states that RTSDatafromWindow is not a data table.
You can view the content during runtime and see the datatype. I assume it’s already a list and needs no conversion.

Was this reply helpful? Yes No
Panuragagra 50 on at

Like
a
(0)

Report
Copy link

Link copied!

here is the value of RTSDatafromwindow..
How do i get each row "Claim Status" column value from this variable ?

Was this reply helpful? Yes No
Gidi 601 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, use split action to make the multiline string to a list. The position of the headers and values seems to be fix values.

Was this reply helpful? Yes No
Panuragagra 50 on at

Like
a
(0)

Report
Copy link

Link copied!

any examples of split action ? appreciate your help? Thanks

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Panuragagra

use split text action for splitting text

But for your question, I think splitting won't help as it did not help to get the required data as it is unstructured format.

First as a step to resolve this, could you please try to extract the data in form of datatable ?

Or if that datatable appraoch i not working
Then using the selector for a cell under Claim Status column, check if there is any incrementing number which increases by constant value when you move from one row to another. If there is, you can use that and increment it dynamically with help of variable .

Hope this helps 🙂

Was this reply helpful? Yes No