You’re offline. This is a read only version of the page.
10
Need suggestion on how to handle the following Forms Survey into CRM Dynamics via power apps:
Forms (Mutiple choice selection and Other entry) example:
The answer comes in like or more complex adding Other entry:
Currently using Excel one drive to map to CRM Choices:
Example Table Ethnicity:
Selection: Choice Option
African 17000000
Asian 17000001
ETC
Other 1700008
This maps in power automate to the CRM Integer needed. Other and Single entry works great but cannot get multiple selections to work.
What option would split out the variable choice options: ["Asian", "African", "Other Text Write in"] so they can be independently looked up in Excel to get corresponding row?
These are the steps I am taking in Power Apps:
Initialize Var
Initialize Var Other
Compose Var 1
Trim Outputs of Compose Var 1 to remove [ ]
Set Var 1 to outputs of Trim Compose
Set Condition
If Var 1 is equal to African or Asia etc...
Flow to Yes Condition Met Else not met and is other and set Write in text to Var Other and Var 1 to Other
Then get row from excel based on outputs of this condition.
Somewhere I need to Count and Split the String and then determine how to store multiple answers in Add a Row to Dataverse
"Asian", "African", "Other Text"
Splits out and looks at each line in excel and then translate to 1700000, 1700001, etc (Int Values)
Thanks for pointing me in the correct direction on this.
@DSonderhouse What option would split out the variable choice options: ["Asian", "African", "Other Text Write in"] so they can be independently looked up in Excel to get corresponding row?
First use replace() to remove [,]," with '' (single quotes without space) and then use split() based on separator comma (,) then you will get array of all elements from this string after that use get row from excel based on each array element.
Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.
#1
rpersad
16
#2
David_MA
10
Super User 2025 Season 1
#3
Michael E. Gernaey
8
Super User 2025 Season 1
Share
Report
All responses (
Answers (
