You’re offline. This is a read only version of the page.
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?
I previously tried using Monday's export to excel feature, but it transports everything and the subitems slide one column to the right, making the data very cluttered. I would like to use Power Automate to iteratively pull data from specific columns. Can you provide an outline for a flow that achieves this?
You can export the entire board to Excel.
3 dots in the very top right of the board, More Actions, Export Board To Excel
Make sure "Include Subitems" is checked.
Might be easier to do once you have the board in Excel, and go from there. Good luck!
#1
eetuRobo
98
Super User 2025 Season 1
#2
Nived_Nambiar
20
Super User 2025 Season 1
#2
CU12050101-0
20
Share
Report
All responses (
Answers (