How to update Multi CHOICE field in SharePoint from Canvas Application

Update Multi Choice field in SharePoint from Canvas Application

In this post, we will see how can we update a Multi Choice field in SharePoint List from canvas application.

Since Multi Choice Field holds data in array, we cannot be able to update it directly how we do "Text Field" or "Number Field". So, to achieve this we can leverage ClearCollection to store the data and update it back to the SharePoint List.

Used Components for this post.

Gallery Control : galTools

ClearCollection : colTeams (to store the multi choice data in the record)

In order to update the Multi Choice field - we are using PATCH function.

Scenario: We have a list of tools in a list and a multi choice field (Teams) which stores which team is using that tool. Any team can login to canvas app and update their team by clicking "Add" and "Remove" buttons in the gallery.

If Team A using a tool and when it is no longer in user, then can click on "Remove" button. When Remove button is click we update Multi Choice by removing "Team A" from it.
If Team B wants a tool to use, team can click on "Add" button. When Add button is click we update Multi Choice by adding "Team B" to it.

ClearCollect(colTeams,ThisItem.Teams);

Patch(colTeams,Defaults(colTeams),{Value:"Team A"});

Patch(Tools,LookUp(Tools,ID = galTools.Selected.ID),Defaults(Tools), {Teams:colTeams})

Comments

Validate an email input in a Canvas Application | PowerApps

Validate an email input in a Canvas Application | PowerApps In this post let us see, how to Validate an email input in a Canvas Application UI Validations helps us to ensure, valid data is received from the End User to complete an operation helps end user to provide right information the validation action depends on the type of the input control for Text Input Control - mostly we go with "OnChange" for check box control - "OnCheck and On uncheck" for Drop Down and Combo Box Controls - "OnChange" or "OnSelect" etc., Now, let us see how can we validate an email input, a phone number input and a name input. How to validate an email input value is valid? We can leverage "Regex" (Regular Expressions) to valid user inputs. Let us consider the Email Input Control Name as - txtEmail.Text. OnChange of this Control let us i...

Success confirmation on a record submission - Canvas Application

In this post let us see, how to show a successfully submitted record's data back on to the form, as a confirmation. Take two screens Home Screen Success Screen On Home Screen: Take a Form Control on the Home Screen and map it to respective entity. In this post we are mapping it to Registrations entity. Take a Button Control and input the below expression, to create records into Registrations Entity. SubmitForm( frmRegistration ) Now, let us implement how to redirect the user to Success Message screen to successful record submission. In order to achieve this, we are going to make use of one of the Form Control's properties - OnSuccess. So, OnSuccess we are going to implement Success Screen navigation as below Navigate(' Success Screen ') Success Screen Take a label to show - success message, as below "Registration was successful. Registration Id: " & frmRegistration .LastSubmit.'Registration Number' LastSubmit property of a From Control helps u...

Convert an array to string in Power Automate (MS Flows)

converting an array value to a string using Power Automate out of the box function. " how to convert an array to string " in MS Flows. Basically, we can use "split" function to convert an array into string but we may end up having extra comma to the last value. To remove that we have to use another expression which checks for the string length and removes the last character [ substring(variables('varListOfRequestIDs'),0,sub(length(variables('varListOfRequestIDs')),1)) ]. To avoid this round about process rocess, we can leverage Power Automate's simple and out of the box function - join Here is an to show how can we convert an array to string. for instance let's consider, we have an array [796759,933436,926050,1388108,762632,764554]. But as per the requirement, we need to convert it to string and send that value as 796759,933436,926050,1388108,762632,764554. varListOfRequestIDs = [796759,933436,926050,1388108,762632,764554] varStringListOfRe...

MS Power Assist

Search This Blog