I would like to extract only specific column data from the table. For example, in the following table I want only 'WK1' data when the loop is run
Email | WK1 | WK2 | WK3
[email protected] | 0 | 0 | 0
[email protected] | 1 | 0 | 0
Any leads on how to fetch based on the column name? the column name is not fixed and on each run it may change based on other fields.
I am assuming that the you need to capture the all rows data in an Array variable for a particular column (Wk1, WK2 etc.) dynamically.
Your dynamic column name has to come from somewhere. Let's assume that you are able to get your column name. Follow the step below to do what you want to achieve.
Step 1 - Initialise a variable ColumnName and assign you column name dynamically.
Step 2 - Initialise a variable DataSource of type Array
Step 3 - Insert a step Append to array variable inside For loop.
Step 4 - Use below mentioned formula to get the value from item() property for your dynamic column name. You can simply put it in expression field.
string(item()?[variables('ColumnName')])
Append to array variable, but i used Select and could filter the required column.
Since you asked for "any leads" this below example will pull various intersections from a table. It is indeed pulling specific columns based on their names (not position). What's likely tripping you up is that to get column data, you have to get a row first.
In the below example, I have an excel call that gets a specific row within the table (by matching the column Guid with a value that matches a Form Submission). From that point, you can see my email template that inserts a bunch of green fields that are actually the column names from my table for the specific row I specified.
Here's a view of the table it might be pulling from.
Guid itself is a variable. column i want to fetch is not fixed. So is there any way to give variable in that place?