Bear with me, I'm new at this!
So I figured out that I cant add data in to my macro excel files so I think I'm going to have to make a new normal excel, copy the data into that and use a macro within excel to pull that data back into it if that's posable, that said if theres a way around this I'm all ears!
That said I have a flow that triggers from a new asana task, it copy's a premade excel book into a new folder on OneDrive with the task name as the folder name, works fine!
This is where I need help! I need to pull the rest of that data from all the fields in that asana task and put it in that new macro excel book file or at lease a normal one! everything I try seems to fail? could someone show me how to string this properly, been at it for hours lol I'm sure this is a 30 sec thing for most of you.
Did you ever find a solution to move all the info from the Asana task to an excel row?
Can anyone help me with a path to take? im still having problems with this, one is pulling all the info from the task as there is custom fields and only think that i can seem to find is task name and description! i do have the option to put all the info from the asana form into the description but that leads to 2 problems, first all that info ends up in one cell on excel and 2nd problem is i dont want it to show up like that on my asana board as i use that for our job progress tracker
another option is i can use Microsoft forms, works for getting info into its own cells on excel but then same problem with asana, all the info is in only 2 places and i dont get the same options with Microsoft like multi select in the form creation.
i do have some problems with excel and i also want to upload the contact info to quickbooks online and not seeing a option except desktop but i guess one problem at a time
Hello, @ssoundwave!
If I'm not mistaken, the trigger requires for the tasks to be part of a project, right? My approach would be to try listing all the tasks inside that project and filter it to get the last task created. Once I have the ID of that last task, I would use the action "Get task by ID" to get all the properties of that task. Perhaps someone with more experience using Asana could help you with this logic.
To my understanding, creating and populating an Excel file in the same flow is not possible, but I believe there's a workaround for this issue, I'll leave you here this option I found: "Create and fill an Excel file dynamically with Power Automate » Benedikt's Power Platform Blog (benediktbergmann.eu)".
Cheers,
Rodrigo
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional