Patch Error

[RJF61]

I have the "Patch" below but an receiving the following error...The type of this argument 'SFCraft' does not match the expected type 'Text'.  Found type 'Record'. 

ForAll(Filter(Gallery3.AllItems,Checkbox5.Value = true),Patch(ShortFormDetail,ThisRecord,{
SFCraft: Dropdown2.Selected,SFCraftEHrs: textiEstHrs.Text,SFCraftRate: Label11.Text,SFCraftECst: Value(Label11_1.Text)}))

In ShortFormDetail, SFCraft is a Text column.

Suggestions please.

[cdwhite]

Hi @RJF61 

I think your value for the SFCraft field in the patch needs a slight tweak.

You currently have 'SFCraft: Dropdown2.Selected', but you'd probably need SFCraft: Dropdown2.Selected.Value, or something like that. Value could be the name of the field from data source for the dropdown, but adding the full stop after Selected should give you the intellisense to select the correct field.

------------------------------------------------------------------------------------------------------------------------------
If I've answered your question, please mark your post as Solved. You can accept more than one post as a solution.

If my response was a good one, please give it a Thumbs Up!

Visit my blog: https://platformsofpower.net

[RJF61]

Hello @cdwhite Thanks for the response.  I modified as suggested and now I receive...The function 'Patch' has some invalid arguments.'

[cdwhite]

Hi @RJF61 ,

In the Power App studio, is there any red lines under the code or any further hints in the App Checker section that would help better understand the issue with the Patch?

[RJF61]

@cdwhite Git it.  Haven't figured those out?

  

[cdwhite]

Thanks @RJF61 . 

I can't see SFDtlTitle in your Patch statement, I can only see SFCraft, SFCraftEHrs, SFCraftRate & SFCraftECst.
Is your backend data source a SharePoint list and have you renamed the original Title column? Alternatively, do you need to be adding SFDtlTitle to your Patch?

[RJF61]

@cdwhite Sorry...

Yes, data source is SharePoint and yes, I did rename the Title.  I have attempted to use the 'SFDtlTitle' and 'Title' names.

[v-qiaqi-msft]

Hi @RJF61,

Try the following tips:

1). If the renamed column works, keep your formula, if the error indicates that the Title column is required or SFDtlTitle is not recgonized, refer to original Title column.

2). Try to modify the formula as below:

ForAll(
    RenameColumns(Filter(Gallery3.AllItems,Checkbox5.Value),"ID","ID1"),
    Patch(
        ShortFormDetail,
        LookUp(ShortFormDetail,ID = ID1),
        {
            ...
        }
     )
）