Replace the Text Values in a Comma-Separated String With New Number Values While Retaining the Sting Datatype?

[cmanning]

I am working on a Flow where I have an array and I use a Join action to create a comma-separated string.  This string has values that must be converted to a format that will work in Dataverse while retaining the string data type.  This is a test flow for proof of concept as the actual source will not be a hard-coded array but dynamic data from a SP list choice mult-select column (I just used 3 of the values from that SP column).  

So  the flow worked and produced this string: Bid Manager,Solution Consultant,Proposal Manager. 

Now I need to convert each of the three text values with a number (e.g., "Bid Manager" should be converted to 198260000, "Solution Consultant" to 198260001, and "Proposal Manager" to 198260002) the Dataverse equivalent for those choices in that column. 

How do I replace the values in the string with their respective numbers and retain it as the same comma-separated string so the new string = 198260000,198260001,198260002?  

[ekarim2020 · Accepted solution]

One way to do this is to use a "lookup" table.

(1) You could create a JSON object that maps the strings to their Dataverse option values:

(2) Use a Select action to "lookup" the option values:

 

(3) Then finally join the output from the Select action using a comma:

 

Here is the sample runtime output:

Hope this helps:

 
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

 

[cmanning]

@ekarim2020 - Ellis thanks so much for this great solution!  I appreciate you taking the time to respond.