Using variable when patching column based on a choice/table

[Rosie]

Hello,

I am cleaning up my app to use variables (instead of dropdowns) but I can't patch the values from the variable to the datasource.

The values I am trying to patch are based on a choice or table.

When I use following it works: 

'C Grade': dpdCDGrade.SelectedText.Grade

When I use the following it doesn't work:

'C Grade': vGrade

Is there a way to use variables (as this seems best practice) rather than hidden dropdown controls?

Thanks

[turnerj3]

Can you show the rest of the patch code?

[Rosie]

I didn't think it was relevant as it works.

It is the issue that the data types don't seem to match when using a variable.

Here is the full patch code.

Patch(
QPContainers,
Defaults(QPContainers),
{
ContainerID: txtCDContainer.Text,
Orders: LookUp(
QPOrders,
'Order Ref No' = dpdCDOrderNo.SelectedText.Value
),
'Booking Number': dpdCDBooking.SelectedText.Value,
'Visual Check Pass': tglVisualCheck.Value,
'B Type': dpdCDBType.SelectedText.'Bladder Type',
'C Grade': dpdCDGrade.SelectedText.Grade,
'Container Status': 'QP Container Status'.Assigned,
'Code': Code.'2210'
}
);

[LaurensM]

Hi @Rosie,

I expect it to be an issue with the value that is being saved to vGrade. The column C Grade expects 1 option set value (from option set 'PNL Grade') and is receiving a table. You could save and patch an option set value in 2 ways:

//(1) Save the option set value
Set(vGrade, 'PNL Grade'.Value1) //Change .Value1 to a valid option set value

//Patch value would be: 'C Grade': vGrade

//(2) Save the option set
Set(vGrade, 'PNL Grade')

//Patch value would be: 'C Grade': vGrade.Value1 
//Change .Value1 to a valid option set value

You might be using UpdateContext instead of Set, which is fine as well - I just used Set as an example.

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

[Rosie]

Thanks for your help.

I need to give you more context I think.

An order is created which determines the grade.  There is an Orders table, the Grade is determined by a Choice.

When a container is assigned to an order, the grade information comes from the Order and is recorded against the container.  In the Containers table the Grade column is determined by the same Choice.

I have set the variable - but using Update Context.

UpdateContext({vGrade:Filter(QPOrders, Booking = dpdCDBooking.SelectedText.Value).Grade})

When I check I am getting the correct value in the variable I use a dropdown box to see the value

I am having trouble patching the value to the Container table's record as shown in the error message included.

[turnerj3]

You may have done this already but click on the 3 ellipsis on the right of settings and check your variables.

See if it gives you any more info into how it is being stored.

[Rosie]

I had a look, and it doesn't really make sense.  Just a ?.  Yet using the same variable in a dropdown box returns a result so I think something is not displaying right in PowerApps for the variables.

I don't know what to make of this.

[LaurensM · Accepted solution]

Hi @Rosie,

You are currently trying to save a table of choice options (Filter returns a table, even when only 1 record is returned). I would recommend using LookUp instead (only retrieves 1 record / column value), which will solve the issue that you are having:

UpdateContext({vGrade:LookUp(QPOrders, Booking = dpdCDBooking.SelectedText.Value).Grade})

The dropdown is displaying a value since it expects a table of rows which is what the filter returns - yet a choice column in a patch only expects an option set value. 

I hope this helps!

[Rosie]

Thanks so much, that does make sense.