I have been on the Power Automate kick lately and it's been a very interesting journey so far to find all the different ways that Power Automate can help augment ProntoForms!! This one was inspired (as they mostly are) by a problem that was brought up to us when building out a form and destinations for a customer.
There are times when you might need to write to a List but also use that same list as a data source for your forms. When writing multiselect data into a MS List (or any other destination) ProntoForms will save it differently then how we would need it formatted so that you can use it for a data source. This will keep the original data intact and push the newly formatted values into a new column.A destination will write a multiselect answer like this: [Option 1, Option 2, Option3] But a data source needs it formatted differently (with new lines separating the values): Option 1Option 2Option 3We can use Power Automate to format the data how we need in order to use it as a data source in the future. The trigger we will use is the “When an item is created”, point this to your Site and List where ProntoForms is writing data to. Next is take the string that we write to the List and replace the commas with new lines. For this, we will use the Compose action for our next step:
If NO, we will update the new row with the same value as was originally writtenFULL FLOW SCREENSHOTS