Skip to main content

Notifications

Community site session details

Community site session details

Session Id : Y0oYdgaNSA9c2ciZ6e82W4
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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Loading started