I am attempting to Add Option to Custom Field dropdown in Trello from a new row created in a Google Sheet. Would sincerely appreciate some help wrapping this one up! I am sure it’s my lack of experience…But I have been trying different method and instructional videos for a week now…
I have a successful flow from Trello to a new row in google sheets.
I have another Flow that is partially successful…(I can get a new option added but only one that I manually type in. I can not figure out how to reference the trigger and pass that to the Custom Field Drop Down Menu.)See image below…
1st Step: Trigger= Google Sheets - New Row Added
2nd Step: HTTP Request Configuration (that I am wanting the New Row added text to be sent as an option in the dropdown in Trello)
Trigger:
~steps.trigger {2}
- context {15}
- event {4} ~newRow [1]
0: Postman 3 Inc. (<------That is the result I need sent to Trelllo custom field drop down as an option)
range: Sheet1!1:1012
HTTP POST Headers look like this:
- User-Agent — Pipedream1
- Content-Type — application/json
- key — private
- token — private
- id —(My customfield id)
- idModel — (My board id)
Body That works if I manually enter the text… This is where I am messed up… Not sure how to properly reference the Trigger and pass that through to Trello in order to add the option to the custom field dropdown. You can see that I can pass through “CrazyTop” just fine… Just can’t get the right things in place to pass through the new row text from the Trigger… Help???
