Unable to reference a string value in a record using patch function

[swinterrowd]

I am running a test and I am new to Power Apps. The following code does what I want except that the value in the Name column of the Table = "Full Name" after it runs. I want it to be the value of the column Full Name after it runs. How do I identify the column name to the Patch function? I tried using ThisRecord. However, ThisRecord does not show me any columns when I am using the dot notation. 

ForAll( [ucbitsec_accesss], Patch(ucbitsec_accesss, LookUp(ucbitsec_accesss, 'Last Name' = "Winterrowd" ), { Name: "Full Name" } ()

Please help

[Pstork1]

You do need to use ThisRecord.Columnname But your current ForAll won't work anyway since Lookup will always return the first record that matches the expression.  I believe what you want to do will look similar to below.

ForAll( Filter( [ucbitsec_accesss], 'Last Name' = "Winterrowd" ),Patch(ucbitsec_accesss, thisRecord , { Name: ThisRecord.'Full Name' } )

[Prabhakar_S]

Hi @swinterrowd ,

Try this,

ForAll(
ucbitsec_accesss,
Patch(
ucbitsec_accesss,
LookUp(ucbitsec_accesss, 'Last Name' = "Winterrowd"),
{ Name: ThisRecord.'Full Name' }
)
)

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

[WarrenBelz]

@swinterrowd ,

I will throw in another issue here - generally you cannot update a data source with itself, but you can get around it like this assuming you are using SharePoint here.

With(
   {
      _Data: 
     Filter(
         ucbitsec_accesss,
         'Last Name' = "Winterrowd"
      )
   },
   Patch(
      Devices,
      ForAll(
         _Data As _Items,
         Patch(
            ucbitsec_accesss,
            {
               ID: _Items.ID,
               Name: _Items.'Full Name'
            }
         )
      )
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[swinterrowd]

Patch(ucbitsec_accesss, LookUp(ucbitsec_accesss, 'Name' = "1118"), {'Middle Name': "testName"})

The following code leaves my table values as shown in the capture image above. Great. Now I would like to move the value in the Full Name column to the Middle Name column (it is a test). I am unable to make the Patch command work with anything except a literal string. Please tell me how I refer to the "Full Name" column instead of the literal "testName" string. 

[Pstork1]

updateContext({temp: LookUp(ucbitsec_accesss, 'Name' = "1118").'Full Name' });
Patch(ucbitsec_accesss, LookUp(ucbitsec_accesss, 'Name' = "1118"), {'Middle Name': temp});

I'm not sure you can do it inline. But you could do a Lookup just before the patch to retrieve the value and store it in an context variable. Then use the context variable to update the value.

[swinterrowd]

Pstork 1-Thanks for the responses. I appreciate your replies.

The code you suggest works fine. However, the problem I am having is that I want to put the code inside of a ForAll loop as shown. 
ForAll
(ucbitsec_accesss,
UpdateContext({temp: LookUp(ThisRecord, 'Name' = "1118").'Full Name' });
Patch(ucbitsec_accesss, LookUp(ThisRecord, 'Last Name' = "Reid"), {'Middle Name': temp})

The following "inline" code works also:
Patch(
ucbitsec_accesss,
LookUp(ucbitsec_accesss, 'Last Name' = "Winterrowd" ),
{
Name: Concatenate(LookUp(ucbitsec_accesss, 'Last Name' = "Reid" ).'Last Name', ", "
, LookUp(ucbitsec_accesss, 'Last Name' = "Reid" ).'Middle Name', ", "
, LookUp(ucbitsec_accesss, 'Last Name' = "Reid" ).'First Name')}) 

Once I do that, according to the error message I am getting, the Lookup function cannot use the same datasource as the ForAll loop. In my mind, the code should then reference the current record inside the ForAll loop for the values it needs. I thought I should be able to reference the item in the ForAll loop's data source using "ThisRecord" as shown in the code above. If you can let me know where I am not understanding this, it would be a great help.
I am looking for an alternative to using the LookUp inside the ForAll loop.   

[swinterrowd]

I do not understand how to reference the loop variable from inside the loop. 

[swinterrowd · Accepted solution]

ClearCollect(
MyCollection,
ucbitsec_accesss
);

ForAll( MyCollection, Patch( ucbitsec_accesss, ThisRecord, { Name: 'Full Name'} ))