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

[TimoToothousand]

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.

[TimoToothousand]

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]

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.

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:

The flow works successfully as below:

Best regards,

Kris

[TimoToothousand]

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.