Trello to excel

[Anonymous]

Hi,

I am new to Power Automate / Flow and want to know if the below scenario is possible ?

Could only see 2 triggers at the moment - when a NEW card is added to board or List.

 I have a Trello Board and each card (with Custom Fields ) in all the List gets updated every day.

 Aim : Would want to essentially fetch all the data that exists in the Board at a scheduled time to an Excel sheet.

Thanks

[ChristianAbata]

hi @Anonymous  in Tello you can get the default values like Tittle or description.

[v-bacao-msft]

Hi @Anonymous ,

Please try to use List the cards in a board to get all tasks in the specified Board.

Then use Add a row into a table action to add the task details to the specified excel table.

Besides, you could use Recurrence as the trigger and set the Flow to be triggered regularly.

Best Regards,

[Anonymous]

Hi @v-bacao-msft , 

Many Thanks for your response.

Could you please help elaborate the solution?

    1. The Trello board has a lots of custom Fields like dropdowns, etc. which needs to be captured.

    2. If I know the structure of my Board, how can I store the updates in a excel table/ SharePoint List ? 

    3. Also, I would want the whole flow to be scheduled at a day's frequency ?

Thanks again.

[v-bacao-msft]

Hi @Anonymous ,

For the first question, you should run the List the cards in a board action to get all task details and check the body to see if you could get the value of these custom Fields.

For the second question, if you have known the structure of the Board and you can get the value of the custom field from the Body of List the cards in a board action, you could create the corresponding field in the list to record details of the task.

For the third question, you could use Recurrence as the trigger and set the interval as 1 day.

There are lots of threads about recording planner task details in SharePoint List/Excel table, you could find it and reference them to configure your Flow to achieve your requirement.

Best Regards,

[Anonymous]

Thanks again @v-bacao-msft .

I am able to extract all Trello data into a custom Sharepoint list,but the hurdle is with Custom Fields in Trello !

Can't see them in Flow, is there any way out ?

Thanks

[v-bacao-msft · Accepted solution]

Hi @Anonymous ,

So if you can’t get the custom field from the body, I am afraid that we could not get them through Power Automate.

We could get the following properties, please check the online doc and get more details about the definitions of a trello card object:

https://docs.microsoft.com/en-gb/connectors/trello/#card

Best Regards,