Hello,
I am trying to create a PA Desktop flow that transports data from a cloud-based project management website called monday.com to an empty excel spreadsheet. I have a board in monday that has several items, and each item has at least one subitem. My goal is to sequentially transport certain column values of every subitem in the board to a given column in the excel spreadsheet.
The main issue is figuring out a way to store the monday board in a variable that can be iterated over. I can store its link in a variable but that stores the entire page, I just want to store the board. If the board can be stored in a variable, I would be able to use a double nested for each loop to iterate through and pull the column values I want from the subitems.
Below are images of both the monday board and the excel spreadsheet and how the data is supposed to be transported. How can I create this flow?
