cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Send SharePoint list data to a new Trello card using dynamic content to determine the Trello list.

I'm trying to create a system that will make new Trello cards for work orders when my client submit them.  The data goes into a SharePoint list with qualities such as Work Order ID number and Client ID Number.  My Trello lists are titled by "Client #" and then the client's number.  When I put dynamic content into the Parent List ID field of the Create a Trello Card action, the flow fails every time.  If I select one of the lists, it works just fine, but completely defeats the purpose of this system, since all cards would only go into one list.

3 REPLIES 3
New Member

Trello list ID numbers are encrypted.  Even though you can select a familiar name in the Parent List ID field, it has to be converted to the encrypted ID number that Trello sets.  This is why you have to select a list from the dropdown.  So now the question remains:  how do we get around this issue?

Community Support
Community Support

Hi @TimoToothousand,

 

Could you please share a screenshot of your flow's configuration?

Do you want to fill a dynamic content within Parent List Id field of "Create a card" action to create a new card in Trello?

Further, could you please show a bit more about your SharePoint list?

 

I agree with your thought almost, the Parent List Id is encrypted. Actually, the "Create a card" action of Trello connector find the specific Board and Parent List via a series of string which likes a GUID string, such as, the '59ed4de0effc7115f87234d7' represents the Board Id and the '59ed4dfbd6d206f46ca2c712' represents the Parent List Id, the "Create a card" action UI just translate the string (e.g. '59ed4dfbd6d206f46ca2c712') into a friendly name.11.JPG

 

If you want to fill a dynamic content within Parent List Id field of "Create a card" action to create a new card within Trello, please make sure that the Dynamic content filled within Parent List Id field store the encrypted string (e.g. '59ed4dfbd6d206f46ca2c712') . I have made a test on my side and please take a try with following workaround:12.JPG

The flow works successfully as below:13.JPG

 

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for the reply, Kris!

 

To clarify what I'm doing, my Work Orders list gets populated by clients using an online form in which they have to enter their Client ID and Project ID number.  When clients setup a new Project, a new Trello list is created with a title of something like "163."  When work orders are generated, a new Trello card for each work order needs to be created in the appropriate list.  So when Client #163 submits a work order, Flow needs to be able to look at the client number and create a card in that list.

 

It looks like what you suggested is really close to what I'm needing to do, but backwards.  It definitely tells me what I need to accomplish, but I'm not sure how to accomplish it.  If I understand correctly, I just need to convert my Client ID Number value to a the same GUID that Trello uses.  

SharePoint to Trello Flow.JPG

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (11,381)