Hi all! I'm working on making a flow that will get the values of Custom Fields from Trello; as that currently is unavailable with the current suite of Trello actions/triggers. I've tried to use Copilot but it's been no help at all. I've worked it out with some HTTP/JSON steps and now I'm trying to figure out how to get these individual Custom Field values into a format where I could input them into cells in Excel individually, here's an example output from my 'Select' step:
[{"ID":{"id":"6750ac42bd9ec23ce72bf6de","value":{"date":"1965-06-15T16:00:00.000Z"},"idValue":null,"idCustomField":"63fa3b80b023c958ad234103","idModel":"6750abbf9c5182deba1f2857","modelType":"card"}},{"ID":{"id":"6764a10be4495f9cacd9e431","value":{"text":"1146443"},"idValue":null,"idCustomField":"63fa3b80b023c958ad234101","idModel":"6750abbf9c5182deba1f2857","modelType":"card"}},{"ID":{"id":"6764a1142b6beb3cbe6ade30","value":{"date":"2027-12-19T12:00:00.000Z"},"idValue":null,"idCustomField":"63fa3b80b023c958ad2340fb","idModel":"6750abbf9c5182deba1f2857","modelType":"card"}},{"ID":{"id":"6750ac42a80d0f191b7f0ed6","value":{"text":"123-456-7890"},"idValue":null,"idCustomField":"63fa3b80b023c958ad2340f7","idModel":"6750abbf9c5182deba1f2857","modelType":"card"}},{"ID":{"id":"6750ac42e498b39b75779010","value":{"date":"2000-12-15T16:00:00.000Z"},"idValue":null,"idCustomField":"63fa3b80b023c958ad2340f5","idModel":"6750abbf9c5182deba1f2857","modelType":"card"}},{"ID":{"id":"6750ac432a0872ec0da8e91a","value":{"text":"Pam"},"idValue":null,"idCustomField":"63fa3b80b023c958ad2340f3","idModel":"6750abbf9c5182deba1f2857","modelType":"card"}},{"ID":{"id":"6750ac42c7f19d0dfb3c593a","value":{"text":"&"},"idValue":null,"idCustomField":"63fa3b80b023c958ad2340f1","idModel":"6750abbf9c5182deba1f2857","modelType":"card"}},{"ID":{"id":"6750ac4216b31310aa92a355","value":{"text":"example@hotmail.com"},"idValue":null,"idCustomField":"63fa3b80b023c958ad2340ef","idModel":"6750abbf9c5182deba1f2857","modelType":"card"}},{"ID":{"id":"6750ac421f3028973939ac80","value":{"text":"Adam"},"idValue":null,"idCustomField":"63fa3b80b023c958ad2340ed","idModel":"6750abbf9c5182deba1f2857","modelType":"card"}}]
Apologies for formatting, but I just wanted the raw data out there in case it helped anyone answer me here. The goal is to be able to take the highlighted value sections and turn them into an output that I can use in Excel so we could have something like the table below. I've got the file ready to go but I'm stuck on this output step. One important thing to note is that sometimes the values may be empty; if someone isn't married the spouse custom fields will come in without information so I need something that can handle 'null' zero outputs like above.
| Code |
Member Name |
Member Phone |
Member Email |
Spouse Name |
Spouse Phone |
Spouse Email |
| 1146443 |
Adam |
123-456-7890 |
Example@hotmail.com |
Pam |
|
|
Looking for a way to hopefully do this in as few steps as possible but really just need help taking this next step to get things working. Thank you so much in advance for your suggestions?
