I have a flow that triggers when a docusign envelope is signed. It creates a file in a SharePoint library, I then want to update the metadata from the fields that have been populated in docusign (docusign calls the fields tabs).
The output from the docusign 'Get tab values' looks like this
{
"tabs": [
{
"tabLabel": "Registered Company Name",
"value": "123",
"documentId": "1",
"recipientId": "",
"tabId": "",
"tabType": "textTabs",
"prefill": false
},
{
"tabLabel": "Address",
"value": "123",
"documentId": "1",
"recipientId": "",
"tabId": "",
"tabType": "textTabs",
"prefill": false
},
{
"tabLabel": "ISO9001 Expiry",
"value": "123",
"documentId": "1",
"recipientId": "",
"tabId": "",
"tabType": "textTabs",
"prefill": false
}
]
}
I've only included 3 fields here but the full document contains 50+
The only way I can get the metadata into the document is to loop through each tab and use a case statement to match it to the sharepoint column. Very messy and the case statement will be 50 wide.
is it possible to parse the docusign output so I have a table of labels and values so;
from this
{
"tabLabel": "Registered Company Name",
"value": "123",
"documentId": "1",
"recipientId": "",
"tabId": "",
"tabType": "textTabs",
"prefill": false
},
to this
| Registered Company Name |
abc company |
| Address |
123 street |
I would then be able to use a single 'update files properties' action
