Getting data From Excel & Writing back to Excel?

Hi ​@mrod,

Use a Query JSON action in a loop to extract your data into a usable format.
If you provide a sample of the JSON that is extracted and advise which parts you need put into variables, I may have the time to create a simple workflow for you.
 

Thank you, Simon. This is what the data looks like after logging to instance details (after the Query Json step inside the loop). 

In this workflow, I am using Get Table Columns. This is all dummy data that you are seeing. What I am trying to do is read the columns, extract the variables, then use those as branching conditions later in the workflow. Here is an example of the data set (dummy data). So I’d like to extract each column as its own variable, so that in branching conditions I could say something like, “If “EE Type” = Core and EE Status = “Terminated”, Send an Email. 

Thank you in advance for your help.

Hi ​@mrod,

Loop through your column values collection.
Use a regular expression on each current value to extract the text.

(?<=\[").*(?="\])

And then add to a new collection so that you can work with the data elsewhere in the workflow.

Thanks, Simon. I will try that!