Skip to main content

Notifications

Community site session details
Power Automate - Building Flows
Answered

Change value in arrays

Like (0) ShareShare
ReportReport
Posted on 6 Aug 2022 01:09:04 by

Hi, I'm not sure if what I am asking for is possible in a very simple solution. The question is 

 

Is it possible to change the values in an array using a switch? (Explanation below)

 

I am wanting to create new records in Microsoft Dynamics 365 based on a web form submission.

 

Originally the field I am now having trouble with was a single select field and I was able to change the value of that field by using a switch. My steps were

 

Initialise Variable: Identifying the field from the webform (String)

Initialise Variable: Creating a variable for CRM (Integer) and then 

Switch: to change the string value to an integer.

 

This has worked perfectly until the web form design changed and now the field has been changed to a multi-choice field which presents as a string. I have converted into an array and we have a very long and tedious "replace" expression which replaces the different strings to the appropriate integer. There are over 50 values I need to convert with new topics being added. One of the main reasons I want to change how I am managing this is if the options selected are

 

{Arts

 Arts and Design

 Darts}

 

then the replace command changes the string to

 

{166000

 166000 and Design

 D166000}

 

Which is obviously incorrect. I don't need a resolution for this because I have fixed it already, but with new topics being added to the list I don't want to have failures because of this oversight. I've looked high and low for a possible answer and thought I'd just come and ask the brains trust.

 

Is it possible to change the values in an array using a switch?

 

Thanks

  • Ellis Karim Profile Picture
    10,936 Super User 2025 Season 1 on 19 Aug 2022 at 16:17:52
    Re: Change value in arrays

    If I still remember correctly, you could still use the same flow but with a small change.

     

    Place the submission from your web form into the varStudyArray:

     

    Snag_1082094b.png

    Snag_1085f5b0.png

     

    Snag_108655b2.png

     

    Hope this helps.

     

    Ellis

  • MayaD Profile Picture
    on 19 Aug 2022 at 01:37:08
    Re: Change value in arrays

    @ekarim2020 

    I hope you have time for me to ask another question that is a bit of an extension of my previous problem.

     

    If our process changed, and submission of our web form was restricted to single choice, ie. I am no longer required to change a string into an array, how could I change the value of a string using a similar methodology as you have demonstrated.

     

    I followed your previous instructions for the values in an array exactly and it worked, but it was not done with a clear comprehension of how the expressions and steps actually work (if that makes sense). sometimes it takes me a bit of time to get around this stuff because I'm not a developer and am always on a journey to understand these technicalities.

     

    Cheers Maya

  • MayaD Profile Picture
    on 10 Aug 2022 at 03:02:10
    Re: Change value in arrays

    @ekarim2020 This is solution has worked perfectly! I can clearly see each value and can update the list easily if changes are made to the webform.

     

    It recognises the whole string which means I'm not getting partial updates (like what I was trying to explain with values like "Darts" or "Carts".) This was caused by the replace expression which wasn't the ideal solution.

     

    Your outline and explanation was perfectly clear as well. Thank you so much! I really appreciate it.

  • Verified answer
    Ellis Karim Profile Picture
    10,936 Super User 2025 Season 1 on 09 Aug 2022 at 23:10:56
    Re: Change value in arrays

    What I was proposing is that we can take an array of study areas to create Dataverse option set values that can then be used to update a Dataverse row. This will make the flow less complex than using mutliple conditions or switch actions

     

    (1) Using a table of values

    Snag_505436c8.png

    A sample flow is given below.

     

    Snag_50462509.png

    ekarim2020_0-1660083294725.png

     

    Snag_5046f7ca.png

     

    We will use a new array to store the option set values - we can't change array items - but we can append values to a new array:

    Snag_50479dbe.png

    Snag_504c41ea.png

    Snag_504ec9ce.png

    What happens to Study Area values that don't have a corresponding dataverse option set value? The flow currently ignores them. This is the area where I'm not clear on how you will handle this, but you could simply map them to a value. If the labels (from the webform) don't match any dataverse options, you can use the table to map it for you:

     

    {
      "Arts and Humanities"166000001,
      "Business"166000002,
      "Indigenous Knowledge"16000003
      "I don't know": 166000005
    }

    (2) Keep Study Areas where there is no option set value:

    ekarim2020_2-1660085557716.png

     

    Snag_5068a30d.png

     

     

    Snag_5065a9a3.png

    if(equals(variables('varTable')?[item()], null),item(),variables('varTable')?[item()])

    ekarim2020_1-1660085369742.png

    (Note that the resulting array now includes a mix of integers and strings)

     

    (3) Sorry, I still didnt understand the different submissions and how you manage them.

    What I mean by this is, if there is a submission of "Arts", "Darts", "Carts"...

    I think you are saying that the webform allows the user to select subject areas Arts, Darts.. etc?

     

    We could map the "variations" of each subject area to the same values:

    {
    "Arts and Humanities": 166000001,
    "Arts": 166000001,
    "Art and Design": 166000001,
    "Darts": 166000001,
    "Business": 166000002,
    "Indigenous Knowledge": 16000003
    }

    Snag_50772180.png

    Snag_5078ea1b.png

    Any duplicate values from the resulting array (varDataAray) can easily be removed:

    ekarim2020_3-1660086321926.png

     

    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.

     

  • MayaD Profile Picture
    on 09 Aug 2022 at 02:57:52
    Re: Change value in arrays

    Hi Ellis

    Thanks for responding again. Here are the answers to your questions.

    1. We have an option set in our dataverse where the integers are defined but they do not match the option set values that are on the webform (which is why i have to map them manually rather than use some clever look up process)

     

    2. I do not want to search the studyarea string for the word "arts" in text like "Darts", "Harts", "Carts". This is the problem I'm trying to avoid. What I want is for the system to realise that there are unique values which should be considered in whole and not in part. This is presented as a string upon submission but can easily be converted to an array. What I mean by this is, if there is a submission of "Arts", "Darts", "Carts", only the first value "Arts" should be 166000 and any other string which contains the string 'arts' is ignored.

    The new array would look like "166000", "Darts", "Carts". At the moment with the replace expression I have the new array would look like "166000", "D166000", "C166000" which is undesirable.

     

    3. I have successfully used a switch to change a string, but I have not been able to work out how or if it is possible to change variables within an array using a switch (which is basically what my original question is)

     

    4. Yes, the data from the form is actually written as a string which I then convert into an array. It comes in looking like this. 

    buzz2095_0-1660011960371.png

     

    5. I'm not sure what more I can show you of the flow for more context? I'm really stuck with converting the information.

    - Webform is submitted with a multi-choice field, this is presented in a string. In the screen shot above the three unique variables are "Arts and Humanities", "Not Sure Yet", "Indigenous Knowledge"

    - I need to change these values to their corresponding value from an option set within the dataverse, however, the labels don't match so I need to map it manually.

    - I want to use a switch but don't know how I can do this. Not sure how I can "Apply to each" or if it is even possible.

     

    I'm not sure if this information has made anything more clear.

  • Ellis Karim Profile Picture
    10,936 Super User 2025 Season 1 on 08 Aug 2022 at 08:51:23
    Re: Change value in arrays

    Hi   @buzz2095 

    (1) Do you already have a list of subjects and integers defined that you can use in your flow, such as:

     

    "Arts and Humanities": "166000001",
    "Business": "166000002"
    "Darts": "D166000001"


    (2) Or will you need to search the StudyArea string for the word "arts" in the texts "Darts" "Harts" "Carts" etc and then assign a value?

     

    (3) You could use a switch action with the StudyArea string, but if there are many choices the flow will be unmanageable and you will need to consider a different method, such as a "lookup" table.

     

    (4) Is the data from the Form for the StudyArea an array?

     

    The final output can be stored in an new array that can then be used with Dataverse.

     

    (5) Please share more of the flow to get context and some of the source sample data.

     

    Ellis

  • MayaD Profile Picture
    on 07 Aug 2022 at 23:29:12
    Re: Change value in arrays

    Hi @ekarim2020 

     

    Thanks so much for taking time to respond. I've had a look at what you have posted and I think it's actually quite helpful for a different problem I have - so thanks!

     

    One of the reasons this solution wouldn't work is because the items listed on the web form are different to those in the dataverse, so I need to map for two reason - an integer variable is required for the field and labels are not the same.

    I will try and explain what I am asking through screen shots.

     

    I would like to know if I can use the switch action to change values in an array. One of the issues I have with my current solution is that it is not looking at the whole variable within an array. So when a variable string is "Darts" the expression identifies "Arts" and changes the variable to "D166000" (As an example). When I use a switch for a field that has only one variable in it, the switch will consider the entire variable and ignores that "arts" exists in the word Darts. Does that make sense?

     

    Here are the steps I have for a switch with only one variable in the field.

     

    buzz2095_0-1659914731090.png

     

    then I list my different cases

    buzz2095_1-1659914793111.png

     

    then I am able to use the StudyAreaId to populate the field in the dataverse.

     

    I'm wondering whether something like this is possible with an array. Can I do an apply to each somehow and get the variables to update that way? I don't want to have to maintain three separate switch cases for each variable in the array.

     

    Thanks Maya

  • Ellis Karim Profile Picture
    10,936 Super User 2025 Season 1 on 06 Aug 2022 at 20:53:58
    Re: Change value in arrays

    Hi @buzz2095 ,

     

    I'm not clear on the question question, but it seems like you are asking how to update a choice field in Dataverse with a new value, and if new choice values are added to D365, the flow is able to handle that without generating an error?

     

    I don't work with D65 and very little with Dataverse, but take a look at the following two examples:

    1. Solved: Re: Multiselect option set mapping - Power Platform Community (microsoft.com)
    2. Re: Get Dataverse Choices with Label and ID(Value) - Power Platform Community (microsoft.com)

    May be a mapping table would help with your problem, as long as the text in the webform matches exactly the mappings table?

    {
     "Arts": 166001,
     "Arts and Design": 166002,
     "Darts": 166003
    }

     


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

     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,079 Most Valuable Professional

Leaderboard
Loading started