Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Extract text from multiple Formstack choice field

Posted on by
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
 
 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard