Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Asana to Excel

Like (0) ShareShare
ReportReport
Posted on 29 Apr 2021 22:49:59 by 2

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. 

  • GwenG Profile Picture
    14 on 14 Feb 2024 at 07:35:47
    Re: Asana to Excel

    Did you ever find a solution to move all the info from the Asana task to an excel row?

     

  • ssoundwave Profile Picture
    2 on 04 May 2021 at 23:12:16
    Re: Asana to Excel

    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

     

  • rrovira Profile Picture
    Microsoft Employee on 30 Apr 2021 at 14:05:36
    Re: Asana to Excel

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 212 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 208 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 186

Overall leaderboard
Loading started