cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
buzz2095
Frequent Visitor

Change value in arrays

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

1 ACCEPTED SOLUTION

Accepted Solutions

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.

 

View solution in original post

8 REPLIES 8
ekarim2020
Super User
Super User

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.

 

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

ekarim2020
Super User
Super User

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

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.

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.

 

@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.

buzz2095
Frequent Visitor

@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

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

Helpful resources

Announcements

Exclusive LIVE Community Event: Power Apps Copilot Coffee Chat with Copilot Studio Product Team

It's time for the SECOND Power Apps Copilot Coffee Chat featuring the Copilot Studio product team, which will be held LIVE on April 3, 2024 at 9:30 AM Pacific Daylight Time (PDT).     This is an incredible opportunity to connect with members of the Copilot Studio product team and ask them anything about Copilot Studio. We'll share our special guests with you shortly--but we want to encourage to mark your calendars now because you will not want to miss the conversation.   This live event will give you the unique opportunity to learn more about Copilot Studio plans, where we’ll focus, and get insight into upcoming features. We’re looking forward to hearing from the community, so bring your questions!   TO GET ACCESS TO THIS EXCLUSIVE AMA: Kudo this post to reserve your spot! Reserve your spot now by kudoing this post.  Reservations will be prioritized on when your kudo for the post comes through, so don't wait! Click that "kudo button" today.   Invitations will be sent on April 2nd.Users posting Kudos after April 2nd at 9AM PDT may not receive an invitation but will be able to view the session online after conclusion of the event. Give your "kudo" today and mark your calendars for April 3, 2024 at 9:30 AM PDT and join us for an engaging and informative session!

Tuesday Tip: Unlocking Community Achievements and Earning Badges

TUESDAY TIPS are our way of communicating helpful things we've learned or shared that have helped members of the Community. Whether you're just getting started or you're a seasoned pro, Tuesday Tips will help you know where to go, what to look for, and navigate your way through the ever-growing--and ever-changing--world of the Power Platform Community! We cover basics about the Community, provide a few "insider tips" to make your experience even better, and share best practices gleaned from our most active community members and Super Users.   With so many new Community members joining us each week, we'll also review a few of our "best practices" so you know just "how" the Community works, so make sure to watch the News & Announcements each week for the latest and greatest Tuesday Tips!     THIS WEEK'S TIP: Unlocking Achievements and Earning BadgesAcross the Communities, you'll see badges on users profile that recognize and reward their engagement and contributions. These badges each signify a different achievement--and all of those achievements are available to any Community member! If you're a seasoned pro or just getting started, you too can earn badges for the great work you do. Check out some details on Community badges below--and find out more in the detailed link at the end of the article!       A Diverse Range of Badges to Collect The badges you can earn in the Community cover a wide array of activities, including: Kudos Received: Acknowledges the number of times a user’s post has been appreciated with a “Kudo.”Kudos Given: Highlights the user’s generosity in recognizing others’ contributions.Topics Created: Tracks the number of discussions initiated by a user.Solutions Provided: Celebrates the instances where a user’s response is marked as the correct solution.Reply: Counts the number of times a user has engaged with community discussions.Blog Contributor: Honors those who contribute valuable content and are invited to write for the community blog.       A Community Evolving Together Badges are not only a great way to recognize outstanding contributions of our amazing Community members--they are also a way to continue fostering a collaborative and supportive environment. As you continue to share your knowledge and assist each other these badges serve as a visual representation of your valuable contributions.   Find out more about badges in these Community Support pages in each Community: All About Community Badges - Power Apps CommunityAll About Community Badges - Power Automate CommunityAll About Community Badges - Copilot Studio CommunityAll About Community Badges - Power Pages Community

Tuesday Tips: Powering Up Your Community Profile

TUESDAY TIPS are our way of communicating helpful things we've learned or shared that have helped members of the Community. Whether you're just getting started or you're a seasoned pro, Tuesday Tips will help you know where to go, what to look for, and navigate your way through the ever-growing--and ever-changing--world of the Power Platform Community! We cover basics about the Community, provide a few "insider tips" to make your experience even better, and share best practices gleaned from our most active community members and Super Users.   With so many new Community members joining us each week, we'll also review a few of our "best practices" so you know just "how" the Community works, so make sure to watch the News & Announcements each week for the latest and greatest Tuesday Tips!   This Week's Tip: Power Up Your Profile!  🚀 It's where every Community member gets their start, and it's essential that you keep it updated! Your Community User Profile is how you're able to get messages, post solutions, ask questions--and as you rank up, it's where your badges will appear and how you'll be known when you start blogging in the Community Blog. Your Community User Profile is how the Community knows you--so it's essential that it works the way you need it to! From changing your username to updating contact information, this Knowledge Base Article is your best resource for powering up your profile.     Password Puzzles? No Problem! Find out how to sync your Azure AD password with your community account, ensuring a seamless sign-in. No separate passwords to remember! Job Jumps & Email Swaps Changed jobs? Got a new email? Fear not! You'll find out how to link your shiny new email to your existing community account, keeping your contributions and connections intact. Username Uncertainties Unraveled Picking the perfect username is crucial--and sometimes the original choice you signed up with doesn't fit as well as you may have thought. There's a quick way to request an update here--but remember, your username is your community identity, so choose wisely. "Need Admin Approval" Warning Window? If you see this error message while using the community, don't worry. A simple process will help you get where you need to go. If you still need assistance, find out how to contact your Community Support team. Whatever you're looking for, when it comes to your profile, the Community Account Support Knowledge Base article is your treasure trove of tips as you navigate the nuances of your Community Profile. It’s the ultimate resource for keeping your digital identity in tip-top shape while engaging with the Power Platform Community. So, dive in and power up your profile today!  💪🚀   Community Account Support | Power Apps Community Account Support | Power AutomateCommunity Account Support | Copilot Studio  Community Account Support | Power Pages

Super User of the Month | Chris Piasecki

In our 2nd installment of this new ongoing feature in the Community, we're thrilled to announce that Chris Piasecki is our Super User of the Month for March 2024. If you've been in the Community for a while, we're sure you've seen a comment or marked one of Chris' helpful tips as a solution--he's been a Super User for SEVEN consecutive seasons!   Since authoring his first reply in April 2020 to his most recent achievement organizing the Canadian Power Platform Summit this month, Chris has helped countless Community members with his insights and expertise. In addition to being a Super User, Chris is also a User Group leader, Microsoft MVP, and a featured speaker at the Microsoft Power Platform Conference. His contributions to the new SUIT program, along with his joyous personality and willingness to jump in and help so many members has made Chris a fixture in the Power Platform Community.   When Chris isn't authoring solutions or organizing events, he's actively leading Piasecki Consulting, specializing in solution architecture, integration, DevOps, and more--helping clients discover how to strategize and implement Microsoft's technology platforms. We are grateful for Chris' insightful help in the Community and look forward to even more amazing milestones as he continues to assist so many with his great tips, solutions--always with a smile and a great sense of humor.You can find Chris in the Community and on LinkedIn. Thanks for being such a SUPER user, Chris! 💪 🌠  

Tuesday Tips: Community Ranks and YOU

TUESDAY TIPS are our way of communicating helpful things we've learned or shared that have helped members of the Community. Whether you're just getting started or you're a seasoned pro, Tuesday Tips will help you know where to go, what to look for, and navigate your way through the ever-growing--and ever-changing--world of the Power Platform Community! We cover basics about the Community, provide a few "insider tips" to make your experience even better, and share best practices gleaned from our most active community members and Super Users.   With so many new Community members joining us each week, we'll also review a few of our "best practices" so you know just "how" the Community works, so make sure to watch the News & Announcements each week for the latest and greatest Tuesday Tips!This Week: Community Ranks--Moving from "Member" to "Community Champion"   Have you ever wondered how your fellow community members ascend the ranks within our community? What sets apart an Advocate from a Helper, or a Solution Sage from a Community Champion? In today’s #TuesdayTip, we’re unveiling the secrets and sharing tips to help YOU elevate your ranking—and why it matters to our vibrant communities. Community ranks serve as a window into a member’s role and activity. They celebrate your accomplishments and reveal whether someone has been actively contributing and assisting others. For instance, a Super User is someone who has been exceptionally helpful and engaged. Some ranks even come with special permissions, especially those related to community management. As you actively participate—whether by creating new topics, providing solutions, or earning kudos—your rank can climb. Each time you achieve a new rank, you’ll receive an email notification. Look out for the icon and rank name displayed next to your username—it’s a badge of honor! Fun fact: Your Community Engagement Team keeps an eye on these ranks, recognizing the most passionate and active community members. So shine brightly with valuable content, and you might just earn well-deserved recognition! Where can you see someone’s rank? When viewing a post, you’ll find a member’s rank to the left of their name.Click on a username to explore their profile, where their rank is prominently displayed. What about the ranks themselves? New members start as New Members, progressing to Regular Visitors, and then Frequent Visitors.Beyond that, we have a categorized system: Kudo Ranks: Earned through kudos (teal icons).Post Ranks: Based on your posts (purple icons).Solution Ranks: Reflecting your solutions (green icons).Combo Ranks: These orange icons combine kudos, solutions, and posts. The top ranks have unique names, making your journey even more exciting! So dive in, collect those kudos, share solutions, and let’s see how high you can rank!  🌟 🚀   Check out the Using the Community boards in each of the communities for more helpful information!  Power Apps, Power Automate, Copilot Studio & Power Pages

Find Out What Makes Super Users So Super

We know many of you visit the Power Platform Communities to ask questions and receive answers. But do you know that many of our best answers and solutions come from Community members who are super active, helping anyone who needs a little help getting unstuck with Business Applications products? We call these dedicated Community members Super Users because they are the real heroes in the Community, willing to jump in whenever they can to help! Maybe you've encountered them yourself and they've solved some of your biggest questions. Have you ever wondered, "Why?"We interviewed several of our Super Users to understand what drives them to help in the Community--and discover the difference it has made in their lives as well! Take a look in our gallery today: What Motivates a Super User? - Power Platform Community (microsoft.com)

Users online (4,705)