Hello,
I am having an issue with what (to me) seems like a simple problem. Maybe I am overcomplicating the situation, but any help would be appreciated.
Problem:
I am trying to get the value (Name of a Team) from a column (NameofTeam) from a static table (Table1) where the Excel spreadsheet is created dynamically in the current flow I am developing.
I have seen multiple posts that are able to get a column value where the file is static, the list is static, etc but, not for a dynamic Excel spreadsheet.
Steps in Flow:
- List Teams
- I am getting a list of all the Teams in my environment
- Get file Content
- I am retrieving a template Excel file that contains two columns ("NameofTeam" and "FiscalYearEnd")
- Create File
- I am creating a unique Excel file for use later to populate it with the names of Teams in my environment
- Apply to each
- For each Team in my environment I am:
- Checking against a condition where the Team Name contains the text "Client ID"
- If yes
- Add a row into a table
- adds that Team name to the spreadsheet created in step 3 where the condition is met
- If No - excludes from spreadsheet
- List Rows present in Table
- Gets a list of all the rows in the newly created spreadsheet in step 3 so that I can use the data in the flow
This is where I run into an issue. I want to be able to use the Team name for referencing in the flow to accomplish a couple of things. The "NameofTeam" data is clearly there (see below), but I can't figure out how to get it into a variable or compose function to use it. I have tried various methods and posts (for static sources), but all I return is a blank value for the "NameofTeam."
List rows present in a table
- available data is highlighted in yellow. I want to get that value (and the other 15 for each row in the table) into some variable or compose function.
