Update multi-line text column with combined values from text-input control -- Patch()?

[Anonymous]

Hi Power People,

I have a multi-line text field that I need to update with values. I've managed to use Patch() with Defaults() to create new rows. However, I don't want to always create items in my SharePoint list. I'd like to update the existing fields. Please see attached screenshots, thank you!

[RandyHayes]

@Anonymous 

Please consider changing your Formula to the following:

UpdateIf(CAR8D,
    Title = "test1",
    {D1_Team_Identification: 
        Concat(TeamIdentificationGallery.AllItems, 
            CItemSerialNumber_d1 & ";" & FullName_D1 & ";" & Role_D1 & "|"
        )
     }
)

If this still gives an error then post back as to what the error is (hover over the darker red underline in the formula).

I hope this is helpful for you.

[Anonymous]

Thank you so much! I will try it out 🙂

[Anonymous]

Hi Randy,

Please see my three screenshots attached. In the first screenshot you will see my powerapps datacard with gallery. That gallery contains two single line text input fields. I hide the auto incrementing ID field in the form. As the rows are added to the gallery it will increment.

The second screenshots shows my working code! It is proven on the third screenshot, even though I think there is a cache error because it's detecting 'Repeating_Data_Card' as 'D1_Team_Identification'. It does work though! The issue I'm having now is the field values from the two text inputs are always an empty string. I've tried Googling it to see what properties I'd need to change in order to concatenate those values in the Patch(). I've had no luck 😞

Thanks in advance for any assistance!

[RandyHayes]

@Anonymous 

Can you clarify a few things:

1) You are creating/updating 1 record in your list based on all of the values entered in your Gallery?

2) You mentioned an incrementing ID for a reason...is this to say that your items in the Gallery are records from some place?

3) CItemSerialNumber_D1, FullName_D1, and Role_D1...are these columns in your records for the Gallery, or do these refer to the TextInput controls in your Gallery?

[Anonymous]

Hi Randy,

Thank you in advance! Really appreciated! This is very close to being solved once the values are populating this List item correctly.

1) You are creating/updating 1 record in your list based on all of the values entered in your Gallery?

Yes. There is a SharePoint list as the data source. In that SharePoint list there is a List item. Within that List item there is  a column called "Repeating_Data_Card". Every List item will have a column value on that row. Please see screen shot 1.

2) You mentioned an incrementing ID for a reason...is this to say that your items in the Gallery are records from some place?

That incrementing ID variable is "CItemSerialNumber_D1". This is attached to the Team Member "FullName_D1" and "Role_D1". When the "+ Add Member" button is pressed (see screenshot 2) it adds another row to the gallery. The gallery field "CItemSerialNumber_D1" is set to hidden (see screenshot 3).

3) CItemSerialNumber_D1, FullName_D1, and Role_D1...are these columns in your records for the Gallery, or do these refer to the TextInput controls in your Gallery?

"CItemSerialNumber_D1" is being stored correctly (screenshot 1). It is added correctly to the List Item column. The two other TextInput "FullName_D1" and "Role_D1" are always an empty string when written to the SharePoint List item column. 

I am not sure if I need to change something in the properties of those TextInput or in the Set() with the concatenate methods? Hopefully I am explaining well!

[Anonymous]

The auto incrementing unique ID is concatenating to the string literals ";" and "|". So it is in fact writing to the SharePoit List item correctly. It must be a field properties setting in the TextInput "FullName_D1" and "Role_D1"... I could be wrong though. Sort of stumped.

@RandyHayes What do you think? Here is a screencap "FullName_D1" properties:

[RandyHayes]

@Anonymous 

I'm still fuzzy on a couple of points.  I believe some would become clear seeing the formula on the Plus button.

In general though, I believe you might be looking at this a little overcomplicated. 

Your formula, from what I am hearing so far, should be:

UpdateIf(CAR8D,
    Title = "test1",
    {D1_Team_Identification: 
        Concat(TeamIdentificationGallery.AllItems, 
            CItemSerialNumber_d1 & ";" & FullName_D1 & ";" & Role_D1 & "|"
        )
     }
)

If FullName_D1 and Role_D1 are text input controls, then it would be:

UpdateIf(CAR8D,
    Title = "test1",
    {D1_Team_Identification: 
        Concat(TeamIdentificationGallery.AllItems, 
            CItemSerialNumber_d1 & ";" & FullName_D1.Text & ";" & Role_D1.Text & "|"
        )
     }
)

Serial number seems to be a TextInput from your pictures, and I'm not entirely sure how this even fits into anything.

Now, some confusion on my part mounts with the fact that originally you showed "D1_Team_Identification" as the column you were trying to update, but now you mention "Repeating_Data_Card" as the column.  Am I missing something there?

[Anonymous]

This is the add icon code: 

Collect(  
CollItems_D1,  
   {  
      CItemSerialNumber_D1: Text(Last(CollItems_D1).CItemSerialNumber_D1 + 1),
      FullName_D1: "",  
      Role_D1: ""  
   }  
)

[RandyHayes · Accepted solution]

@Anonymous 

The FullName_D1 and Role_D1 will not be needed in that collection, but regardless, the formula I last provided (the second one) is what you are looking for.