Connecting Trello with Excel via Power Automate

[Flavie Measson]

Hello everyone ! 

I have discovered that we can connect Trello with excel via Power Automate (microsoft) but I can't find a way to put the custom fields in different columns or cells. I know there are a lot of  power ups that offer that service for a fee, but I would like to try with Power Automate. 

So, does anyone know how to do this ? If so, how ?

Thank you in advance !

[Brittany Joiner · Accepted solution]

@Flavie Measson what's the automation you're trying to build? Mapping a new card to a row in a sheet? I don't know much about Power Automate, but you can do this with Zapier

[Flavie Measson]

@Brittany Joiner Yes, I heard about Zapier but I wanted to try with with pawer automate of microsoft. And yes, I want to create a new line in excel when a new card is added to a board or a list with the custom fields in different columns (or the other way around)...

I have a question about Zapier: when they mention that the free plan of Zapier allows for 5 Zaps per month, does this mean that the action will be executed 5 times and then stop, or is each "rule" like "create a new line in Excel when a new card is added to a board or a list" considered as one Zap?

Thanks in advance !

[Brittany Joiner]

@Flavie Measson each zap is a rule, so you can have 5 rules on the free plan. I think they limit to 100 tasks (which is each time the rule executes)