Network error patch function

[Anonymous]

Goodday,
I have an issue which i see a good amount of posts about yet i do not see a singular solution which works in my case.
Most people have a sharepoint list as dataset when this error occurs. I however am using an SQL Server with an admin account so all permissions should be fine.

Any help?
See below for more indepth information about the PowerApp
Code: 

Patch(
   'DD.product_subunit_batch_step_timeloss', 
   LookUp(
      'DD.product_subunit_batch_step_timeloss',
      batch_cycle_id = dataholder_batch_cycle_id.Selected.batch_cycle_id
   ), 
   {reason_category_id: input_reason_category_id}
)

I am trying to update the 'DD.product_subunit_batch_step_timeloss',

inserting reason_category_id into it based on task_id.

So i have some hidden placeholders with the next data:
processorder_id based on the full_processorder_dropdown.Selected.full_processorder_id
batch_cycle_id_dropdown dependant on processorder_id_dropdown
then i can use the batch_cycle_id to check if i am inserting the reason into the correct row.
see ERD below to know why i needed these.

[Anonymous]

Hi, I figured out what it has to do with:

Patch(
   'DD.product_subunit_batch_step_timeloss', 
   LookUp(
      'DD.product_subunit_batch_step_timeloss',
      batch_cycle_id = dataholder_batch_cycle_id.Selected.batch_cycle_id
   ), 
   {reason_category_id: input_reason_category_id".?"}
)

See ".?"
If i enter .Text i get this error

If i enter nothing i get the error:

So im assuming it has to do with this part of the code. Any support?

No suggested value which works.

[Charbel_kh]

I don't know exactly what the problem is but I might be able to help you to figure it out.
When I get such unclear errors I open a monitor session for the app in order to get more details about the error.
1- Publish your app
2- Open your PowerApps apps list, select more commands on your app (the 3 dots next to your app), and hit Monitor.
3- A new tab will open. After it loads, select 'play published app' located in the top header at the right.
4- Run the part in your app that generates this error and then go back to the monitor tab.
you can filter the details by the result (success, error...) filter them by error, and select the error that was generated and you will be able to get more details about that error.
I hope that this will help you to figure out what the problem is

[Charbel_kh]

The Error message you received tells you that you are trying to patch a text value to a field of type number
Try to wrap your value with the function 'Value' which will convert the text to number and then send it to SQL.
Try to use 'Value(input_reason_category_id...)' instead of 'input_reason_category_id....'

[Anonymous]

Thanks, I dont know how to use this data to properly find the error. It gives a bit more detail but barely, any screenshots of the errors i can send you besides shown below that could help, helping me?

Error 2:

Error 3:

[Anonymous]

  "message": "A value must be provided for item.
I see this but it doesn't show which Item.
I can only assume it is the input_reason_category_id because i am not specifying the datatype.

[Charbel_kh]

yes this is the type of information I look for in the monitor session but unfortunately, I don't know what this error means.
Again I think that the problem is that you are trying to take a text value and pass it to an int field in sql.
Just to make sure I have a question. what exactly is 'input_reason_category_id', is it a dropdown / combobox or a textfield?

[Anonymous]

It is the text field shown on the screenshots with an ID inside of it(int).
But it is a text field so it thinks its text or something. I don't know how to resolve this.

Reason Category ID

14

the 14 in this case is the text value i am trying to parse in this patch function.

[Anonymous]

With({ cat3 : reason_category3_dropdown.Selected.reason_category_3,
       cat2 : reason_category2_dropdown.Selected.reason_category_2,
       cat1 : reason_category1_dropdown.Selected.reason_category_1,
       budgetsubcat : budget_subcategory_dropdown.Selected.budget_subcategory,
       budgetcat : budget_category_dropdown.Selected.budget_category},
   LookUp(
      'DD.reason_category',
      (IsBlank(cat3) || reason_category_3=cat3) &&
      (IsBlank(cat2) || reason_category_2=cat2) &&
      (IsBlank(cat1) || reason_category_1=cat1) &&
      (IsBlank(budgetsubcat) || budget_subcategory=budgetsubcat) &&
      (IsBlank(budgetcat) || budget_category=budgetcat) ,
      reason_category_id
   )
)

This is my code to get the input_reason_category_id.
It checks all selected reason dropdowns(which have a hierarchy).
If not empty it will take that dropdown and show the connected reason_category_id into this text field.

[Charbel_kh]

try to patch the following:
'{reason_category_id: Value(input_reason_category_id.Text)}'.

Even if the type of your text field is a number it will always return a text when you try to get it's value