cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
obarisk
Frequent Visitor

Get value from object variable by another variable

SomeDataTable is a datatable.

SomeColumnName is a String.

 

Is it possible to get value like

For Each SomeDataRow in SomeDataTable

 

%SomeDataRow["%SomeColumnName%"]%

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Henrik_M
Super User
Super User

Put it like this:

 

%SomeDataRow[SomeColumnName]%

View solution in original post

5 REPLIES 5
Tejashree_G
Helper I
Helper I

if i'm wrong then correct me, you want to read excel row one by one column wise ?

Yes. I'm trying %SomeDataRow[%SomeColumnName%]%

obarisk
Frequent Visitor

%SomeDataRow[SomeColumnName]% pass the code checking, but runtime error as

 

Could not found column or attribute '"ColumnName"'.

 

Quote of quote String. The behavior is mysterious.

as per my understanding, you will need to first read your excel row's and column then you will get " excel data " variable , 2. apply for each action and use "excel data" variable so you will get current item variable (whole row's in data table ) 3. use anther for each under the 1 st for each loop and use "current item " variable, use display msg box to check your output.

Henrik_M
Super User
Super User

Put it like this:

 

%SomeDataRow[SomeColumnName]%

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,228)