Answered

How to patch a text field to a choice column in Canvas Apps

(0) Share

Report

Posted on by Mayank_Yadav

I am making a canvas app in which I have a text field , I want to patch the Value of the text field with a choice column in my dataverse table.

As you may see , I have a Gallery in which I have 3 buttons to show 3 options ["Morning" ,'Afternoon" ,"Evening"], whenever someone selects any of the 3 buttons it is highlighted in red and shown below in text in front of the "Preferred Time selected - " label.

For the Gallery items I have made a collection on the "OnStart" of the App like -

ClearCollect(PreferredTime,{PreferredTime:"Morning"},{PreferredTime:"Afternoon"},{PreferredTime:"Evening"})

Now, I want to patch in the Dataverse table a choice column "Preferred Time" which has 3 choices {"Morning" ,'Afternoon" ,"Evening"}.

I can't seem to find the correct way to implement the above scenerio using the Patch function,

Kindly Help,

your Help will be highly Appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

VishalJhaveri 1,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Refer this master blog to achieve everything related to Patch functionality. Master CRUD Operations in Power Apps : Part 4 (inkeysolutions.com)

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Mayank_Yadav ,

Do you want to patch "Morning" on the label to Choice column of Dataverse Table?

Assuming that you want to create a new record in Dataverse table. Please try this.

Patch(DataverseTable,Defaults(DataverseTable),{ChoiceColumn:Switch(Label.Text,"Morning",ChoiceTable.Morning,"Evening",ChoiceTable.Evening,"Afternoon",ChoiceTable.Afternoon)})//The ChoiceTable is the table used as choices of Choice column, you should replace it with yours table name.

Best regards,

Rimmon

Was this reply helpful? Yes No
Mayank_Yadav 56 on at

Like (0)

Report
Copy link

Link copied!

Hey Rimmon,
Thanks for the Fast reply,

I am not able to understand the patch command, Let me clarify for you,
(1)-I want to create a new record in the "Appointment Table" whenever the user clicks on a Button to Patch a new record in the table,
(2)- The Appointment table has a column called Preferred Time having 3 choices - [Morning,Afternoon,Evening]
(3)- In my Canvas app I have the below scenario
in front of the Preferred Time label I have placed a Gallery, The items of the Gallery is the "PreferredTime" Collection that I have created on the 'OnStart' of the App using this formulae - ClearCollect(PreferredTime,{PreferredTime:"Morning"},{PreferredTime:"Afternoon"},{PreferredTime:"Evening"})
--- The Gallery has 3 buttons whose placeholder Text is - ThisItem.PreferredTime
(4) - Below the gallery I have a label 'Preferred time selected' and In front of this label I have another lable named "SelectedTime" whose text property is - Gallery1.Selected.PreferredTime

-- Now , what I want to patch in the Appointment table's Preferred Time Choice column to the value of the "SelectedTime" text label,
I am making a Custom Page for further Clarification.

Kindly Help,
Thanks & Regards

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Mayank_Yadav ,

The formula in my first reply can archive what you want. If you don't know how to use Patch function, you can follow below steps.

Step1.Add a button.

Step2.Copy below formula to OnSelect of the button.

Patch(YourDataverseTableName,Defaults(YourDataverseTableName),{ChoiceColumnName:Switch(Gallery1.Selected.PreferredTime,"Morning",ChoiceTable.Morning,"Evening",ChoiceTable.Evening,"Afternoon",ChoiceTable.Afternoon)})

After finish above, you can click the button to check if a new record with selected Preferred Time has been created.

Here is also a link about Patch function for your reference.

Patch function (contains video) - Power Platform | Microsoft Learn

_________________________________________________________________________________________________________________________

If my answer helps you solve the problem, please accept it as a solution.😀

Best regards,

Rimmon

Was this reply helpful? Yes No
Mayank_Yadav 56 on at

Like (0)

Report
Copy link

Link copied!

Thanks Rimmon, was Able to implement it this time 👍

Was this reply helpful? Yes No
Mayank_Yadav 56 on at

Like (0)

Report
Copy link

Link copied!

Can you help with Another scenario that has been troubling me Mr.Rimmon

I have a Combobox that I have copied from a form and using it in place of a default combobox that is provided in the tree view ,
I map the gender of the user in that combobox, I have renamed it as 'GenderDataCardValue3'
the items property of the combobox are - ["Male","Female","Other"]

In the Appointment table I have a 'Gender' column that is a optionset and has values - ["Male","Female","Other"]
I try to Patch it to the column like this
- Gender:GenderDataCardValue3.Selected.Value
but it gives me this error - "The type of argument 'hil_gender' does not match the expected type 'OptionSetValue(Gender(Appointment))'. Found type 'Text'."

Kindly help regarding this scenario
Thanks & Regards

Was this reply helpful? Yes No