Invalid argument type for If statement, please help

[OsmandFernando]

When I was trying the If formula under the DisplayMode I am getting the Invalid argument type, Can someone please help 

[OsmandFernando]

@yashag2255  @v-xida-msft  Dear Super users, a bad news though. I tested the code (which received from both of you) quantity , unit price are patching but Model number not. If I changed the model number that is not reflecting in the SP List and no code error showing well. Kindly help. Also is it possible to have a dropdown rather a text box in my Gallery ?

[v-xida-msft]

Hi @OsmandFernando ,

Do you mean that the changed 'Model No' value could not be saved back to your SP list?

I have made a test on my side, and don't have the issue that you mentioned. Please check if you have typed proper formula in your app.

If the 'Model No' field looks up a Number type field in your ItemMasterList, please modify your formula as below:

UpdateContext({EditRecord:""});
Patch(
       SalesDetails_1,
       LookUp(SalesDetails_1,ID = ThisItem.ID),
      {
         'Model No': {
                        Id: LookUp(ItemMasterList, ReferencedColumn =  Value(ModelnumberLable.Text), ID),          /* <-- Modify formula here */
                        Value:  Value(ModelnumberLable.Text)
          },
         Quantity: Value(QtyLable.Text),
         'Unit Price': Value(UnitPriceLable.Text)
      }
)

In addition, if you want to add a Dropdown box within your Gallery instead of Text Input box to list the 'Model No' option values, I think PowerApps could achieve your needs.

Please consider add a ComboBox control (ComboBox1) within your Gallery, then set the Items property to following:

Choices('SPList'.'Model No')

then you could modify your Patch formula as below:

UpdateContext({EditRecord:""});
Patch(
       SalesDetails_1,
       LookUp(SalesDetails_1,ID = ThisItem.ID),
      {
         'Model No': ComboBox1.Selected,       /* <-- Modify formula here */
         Quantity: Value(QtyLable.Text),
         'Unit Price': Value(UnitPriceLable.Text)
      }
)

Please consider take a try with above solution, check if the issue is solved.

Best regards,

[OsmandFernando]

@v-xida-msft There was an issue on the list name from my side. Now model no is updating. Thank you so much. 

Now I am trying to replace with combo box. Following is the way I did and not working

pdateContext({EditRecord:""});
Patch(
SalesDetails_1,
LookUp(SalesDetails_1,ID = ThisItem.ID),
{
'Model No':ComboBox1.Selected ,
Id: LookUp('Item Master', 'Model Number' = ComboBox1.Selected, ID),
Value: ComboBox1.Selected,
Quantity: Value(QtyLable.Text),
'Unit Price': Value(UnitPriceLable.Text)
}
)

[v-xida-msft · Accepted solution]

Hi @OsmandFernando ,

There is something wrong with your formula, please modify it as below:

UpdateContext({EditRecord:""});
Patch(
     SalesDetails_1,
     LookUp(SalesDetails_1, ID = ThisItem.ID),
     {                                               /* <-- Remove the Id and Value argument from the following {} part */
      'Model No': ComboBox1.Selected,
       Quantity: Value(QtyLable.Text),
      'Unit Price': Value(UnitPriceLable.Text)
     }
)

Set the Items property of the ComboBox1 to following:

Choices('YourSPList'.'Model No')

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

[OsmandFernando]

Thank you @v-xida-msft is this correct?

UpdateContext({EditRecord:""});
Patch(
SalesDetails_1,
LookUp(SalesDetails_1,ID = ThisItem.ID),
{
'Model No': ComboBox1.Selected,
Quantity: Value(QtyLable.Text),
'Unit Price': Value(UnitPriceLable.Text)
}
)

I am sorry as my knowledge is little on this

[v-xida-msft]

Hi @OsmandFernando ,

Yeah, you are right. Please take a try with it, then check if the issue is solved.

If you have solved your problem, please consider go ahead to click "Accept as Solution" to identify this thread has been solved.

Best regards,

[OsmandFernando]

@v-xida-msft  Thank you for your reply. But I am getting the error as below, 

[v-xida-msft · Accepted solution]

Hi @OsmandFernando ,

Could you please share more details about the formula you typed within the Items property of the ComboBox1 in your Gallery?

Is there a "Id" column in your SP List, which is marked as Required field?

If there is a "Id" column in your SP List (SalesDetails_1), which is marked as Required, please consider add the Id field as argument within the '{}' part of your Patch formula:

UpdateContext({EditRecord:""});
Patch(
     SalesDetails_1,
     LookUp(SalesDetails_1, ID = ThisItem.ID),
     {                                               /* <-- Remove the Id and Value argument from the following {} part */
      'Model No': ComboBox1.Selected,
       Quantity: Value(QtyLable.Text),
      'Unit Price': Value(UnitPriceLable.Text),
       Id: "Type Specific Number value for it"
     }
)

If there is no "Id" column in your SP List, please make sure the Items proeprty of the ComboBox has been set to the formula I mentioned above:

Choices(SalesDetails_1.'Model No')

Please take a try with above formula, check if the issue is solved.

Best regards,

[OsmandFernando]

@v-xida-msft  Yes correct, I had an issue on the Item property. I have changed it and now it is working as expected. Thank you dear @v-xida-msft  @yashag2255 @mdevaney 

Osmand.