I have a flow that receives submissions from formstack and adds the data to a dataverse table. There are several choice fields in the formstack form, and I have inserted JOIN actions for these to return the value correctly. However, the form designer has for some reason added separate fields for each state (Australia) and if I add a JOIN action for each state, it fails, as seven of the 8 fields are empty values. If I don't have a JOIN action, the result returned to my table is in square brackets and speech marks... eg ["New South Wales Country Club"]
I'm pretty basic with Power Automate, so I'm guessing there is probably a fairly easy way to achieve getting the value without the brackets and speech marks? I have tried googling and attempted a replace(split(variables etc but it didn't work!
Any suggestions???
Thanks