cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ingo
Level 8

How to store user defined properties for Trello

Hello.

 

This is my first post.

MS Flow is realy awesome. I use it to support my daily work.

I use sharepoint lists to track the time I spend in several projects.

When creating a new entry, a MS Flow creates a new Trello card in one f my Trello Boards (Remember to write Invoice).

That works fine.

Now I want to set a column (Invoice done) in my sharepoint list to TRUE, after dragging the corresponding card to the Done-Column in Trello. The problem is, that I do not know how to store the unique identifier of the corresponding entry in the first flow, for usage in this flow.

Any ideas?

Thanks in advance

Ingo

4 REPLIES 4
Microsoft telu
Microsoft

Re: How to store user defined properties for Trello

Hi Ingo,

 

Maybe you can use the "filter query" in the sharepoint, and use some of the outputs from the sharepoint to put it in trello?

sharepoint-trello.png

 

Thanks

Ingo
Level 8

Re: How to store user defined properties for Trello

Hi telu. 

 

Thank you for your reply. 

correct. I would like to use the "ID" from the sharepoint row. 

But when placing it to the trello-card, how can I reuse this ID to point to the row after dragging the card to the "done" column in a 2nd flow?

Microsoft telu
Microsoft

Re: How to store user defined properties for Trello

Hi Ingo,

 

I'm not so familiar with trello, I don't know how to "done" it. it seems a status change for the same card. so I wondering if you can use the following flow use the property from the trello that is the ID

trello-update.png

if it's status associated with the same card, we need to use other way to listen to the change to trigger a new flow.

 

Thanks

Ingo
Level 8

Re: How to store user defined properties for Trello

Thank you.

 

You are right.

I think I have to go a step further and store the row-id of the sharepoint list entry together with the new created trello-card-id in an sql-server table.

Later, when the task in trello is complete (done) a new flow could search in the sql server-table for the card-id - get the corresponding row-id of the sharepoint list - and in the next step of the flow it might be possible to update the row (wich row-id i now know) of the sharepoint-list and set the done-column of the row to true.

I will try this and follow up later.

 

thanks again

Ingo

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,394)