Background:
Forms Survey integration with a multiple checkbox answer such as
English
French
Spanish
All can be clicked
When trying to add a row into Dynamics String presents like this via power apps:
["English"], ["French"],["Spanish"]
When I do a compose and substring I can trim the front and back "" but not the ones in between.
I have been able to get rid of brackets.
I want it to compose like this:
English, French, Spanish
Any suggestions on this formula and what to use for the function?
Then when I pass to a defined array with all the options:
[{
"EntityID":XXXX
"TextName":"English"
},
ETC...
Will it pick up all three strings our to I have parse each string separately to get the integer values to input into Dynamics add a row?
Thanks, Dianne
