For the data received from Microsoft Power Automate, such as the following example: {"Q1":"1","Q2":"[\"Option 1\",\"Option 3\",\"Another Information\"]","EntityName":"UsrInfo"}, how should I record the information so that the values in Q2 are registered in separate columns?
Example:
Q1 – 1
Q2 – Option 1
Q2 – Option 3
Q2 – Other Information
Like
1 comments
20:37 Nov 22, 2024
I don't think the OOTB webhooks will handle that structure. You'll probably have to have it go to a text field, which will store the array as a text string, then use a process on record added to parse it to put in the correct places.
Ryan
Show all comments