Get Table Rows - How to access row data collection

  • 1 December 2022
  • 2 replies
  • 125 views

Userlevel 1
Badge +5

Hi Everyone

 

I have a use case where I need to extract data from excel. Using the Get Table Rows action, I'm able to access the data in the Rows collection but that gives me the index and row data together as one item in the collection. I need to be able to access the Row data so I can use the Get Item From Collection action to extract the required data into variables but it is always greyed out.

 

Does anyone have a solution?

 

27293i0307052B9809C1B3.png

 

 


2 replies

Userlevel 3
Badge +8

Hi,


I think if you use a loop for each, you will be able to get the data from within the loop:





I haven't tested it myself, but the values are available and no9t greyed out if you retrieve them from the loop.

Userlevel 1
Badge +5

Thanks @Prineel_V3 

This helped a lot!  I used the loop for each action but I still wasn’t able to use the get item from collection action to access the required data but by using the loop for each action, the data was parsed in a way that allowed me to access the data via the Query JSON action.  I could not find a JSONPath that gave me the results I required without using the loop for each so thanks 😃

Reply