cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TimoToothousand
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
TimoToothousand
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?

v-xida-msft
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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,650)