I can't update existing data in dataverse table using canvas app

[luisafrancoj95]

I'm creating a canvas app to manage the data within a Dataverse Table, I can create new records in the table using NewForm and Submit Form, however I would like to add edit this record adding additional data. Im trying to create a new form with this new fields (because the people that fill out the first form can't modify additional data) and use patch to pull the data within the table but It displays this error: "Network error when using patch function". I would like to get help about how to achieve my goal. first create the record and then update this record with another data or form. 

[Amik]

@luisafrancoj95 - what is the data type for Priority? Is it a Choice field?

Separate question, why use Patch to Edit data, when users can simply Edit data using the same Form?

[luisafrancoj95]

Thank you..

1. Priority is a choice from the original table 

2. Im using patch rather than edit using the same form because I need to put additional labels and data in the form that I can't display in the first form

[AhmedSalih]

@luisafrancoj95, Choice column of Dataverse need to be compared a choice value and not just a Text value of the choice:

Try this:

Priority= LookUp(AddColumns(Choices(Priority),
"ChoiceValue",Text(Value)
),ChoiceValue=DataCardValue14.Selected.Value).Value

If my reply helped you, please give a 👍  , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

[AhmedSalih]

@luisafrancoj95 and @Amik , fat finger, I accepted my reply as solution by mistake, please ignore. I apologize

[Amik]

@luisafrancoj95 - you're Patch expression looks fine to me. I suspect the likely problem is the Items property of your Dropdown/Combo Box. 

Could you clarify what expression you have in there?

[luisafrancoj95]

I tried with the text field and it works, the issue is with fields with date fields or choice.

[luisafrancoj95]

I tried with the text field and it works, the issue is with fields with date fields or choice.

[Amik]

@luisafrancoj95 - will be difficult to help you if you cannot answer my question. What expression do you have in the Items property of your dropdown control?

[luisafrancoj95]

I tried with the following code but it doesn't work

Patch(Tasks, LookUp(Tasks, Subject=Gallery2.Selected.Subject), {
    'Test column': DataCardValue15.Text,
    Priority: LookUp(AddColumns(Choices('Priority (Tasks)'),DataCardValue14_1.Selected.Value, Text(Value)),ChoiceValue = ChoiceValue=DataCardValue14.Selected.Value).Value
})

It says: "The function 'Add Columns' has some invalid arguments"