Repeating table removing previous records information

[ClarkyPA365]

Hi,

I have a repeating table but I'm missing something as when I create a new record some of my previous records data disappears.

For my navigation button the the screen i have

Add a name in

Select Add New Person icon

+ formula 

What I'm I missing??

[WarrenBelz]

@ClarkyPA365 ,

I am struggling to see the relevance of that post to your current issue with a Person field. The .Result refers to the output of a Distinct filter in the Items of the Combo Box - I have a blog on this if it assists you.

What stage of this are you currently considering - I am a little lost as to exactly what (if it is anything other than the Person field patch) you are now considering.

[ClarkyPA365]

Hi,

My requirements and goal is to be able to select multiple people using the Office365Users connector.  Then depending on the reason display the Exemption reason for the individual.  

But for reporting and the flow that will be activated when a new record is created in SP I need the User (Who signed into to the app, who will be carrying out the supervision meeting)name and email, along with the participants Emails,
Department and Job Titles are also required again for reporting.

Once the participants have been selected they need to be added to SP on a single row.

Currently the name picker is not keeping a record of the selected name so I was trying to add the Text box so the selected name is displayed along with their information (Email, Department, Job Title).  The User name and email will be the only constant data for each record..

[WarrenBelz]

Hi @ClarkyPA365 ,

OK - back to the future . . . .

If you want to Patch to a Person field, you need both the Full Name and Email Address of the person. I am also not the best person to guide you here as I do not use these fields. As an example, if StaffName is a Person field, the Patch would contain

StaffName:
{
   '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
   Claims: "i:0#.f|membership|" & Lower(YourStaffNameEmailHere),
   Department: "",
   DisplayName: ComboStaffName.Selected.DisplayName,
   Email: YourStaffNameEmailHere,
   JobTitle: "",
   Picture: ""
}

[ClarkyPA365]

Hi Warren,

I know this isn't something you use and I can see why.

I've raised another post as I'm getting an error still 'This function 'Patch' has some invalid arguments

Patch(
ExemptionItems,
ThisItem,
{
Supervisor: lblExpSupervisor.Text,
'Supervisor Email': lblExpSupervisorEMail.Text,
'Staff Name':
{ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPlistExpandedReference",
Claims:"i:0#.f|membership|" & Lower(User().Email),
DisplayName:ComboStaffName.Selected.DisplayName,
JobTitle:"",
Picture:"",
Ward: lblExpDept.Text,
'Date Exemption': DateExemp.SelectedDate,
Email: lblExpStaffMail.Text,
Division: lblExpDept.Text,
'Job Title': lblExpJobTitle.Text,
'Exemption Reason': DrpExempReason.SelectedText.Value,
'Other Reason': txtOtherReason.Text
}
);

[WarrenBelz]

@ClarkyPA365 ,
Apart from missing a closing bracket, are all those fields at the bottom in your 'Staff Name" People field? Also is is always the user's record as you have users User().Email in the Claims column.

Patch(
  ExemptionItems,
   {ID:ThisItem.ID},
   {
      Supervisor: lblExpSupervisor.Text,
      'Supervisor Email': lblExpSupervisorEMail.Text,
      'Staff Name':
      {
         '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPlistExpandedReference",
          Claims:"i:0#.f|membership|" & Lower(User().Email),
          DisplayName:ComboStaffName.Selected.DisplayName,
          JobTitle:"",
          Picture:"",
          Ward: lblExpDept.Text,
          'Date Exemption': DateExemp.SelectedDate,
          Email: lblExpStaffMail.Text,
          Division: lblExpDept.Text,
          'Job Title': lblExpJobTitle.Text,
          'Exemption Reason': DrpExempReason.SelectedText.Value,
          'Other Reason': txtOtherReason.Text
      }
   )
);

[ClarkyPA365]

Hi Warren,

Here is my SP list column names

Is it worth me just re-doing this as it seems to be having issues with this at it every step 🤔

Would you be able to assist?
I think you know the scenario and what I want the application to do  

[ClarkyPA365]

Hi,

The 'Staff Name',  SP column is a Single line of Text field.

I've changed the formula to
Patch(
ExemptionItems,
ThisItem,
{
Supervisor: lblExpSupervisor.Text,
'Supervisor Email': lblExpSupervisorEMail.Text,
'Staff Name':
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPlistExpandedReference",
Claims:"i:0#.f|membership|" & Lower(ComboStaffName.Selected.Mail),
Department:"",
JobTitle:"",
Picture:""
},
Ward: lblExpDept.Text,
'Date Exemption': DateExemp.SelectedDate,
Email: ComboStaffName.Selected.Mail,
Division: lblExpDept.Text,
'Job Title': lblExpJobTitle.Text,
'Exemption Reason': DrpExempReason.SelectedText.Value,
'Other Reason': txtOtherReason.Text
}
)
)
;

[WarrenBelz · Accepted solution]

@ClarkyPA365 ,

You now have an extra bracket and are missing DisplayName in the Person field - so for a Person field

Patch(
   ExemptionItems,
   ThisItem,
   {
      Supervisor: lblExpSupervisor.Text,
      'Supervisor Email': lblExpSupervisorEMail.Text,
      'Staff Name':
      {
         '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPlistExpandedReference",
         Claims:"i:0#.f|membership|" & Lower(ComboStaffName.Selected.Mail),
         DisplayName:ComboStaffName.Selected.DisplayName,
         Department:"",
         JobTitle:"",
         Picture:""
      },
      Ward: lblExpDept.Text,
      'Date Exemption': DateExemp.SelectedDate,
      Email: ComboStaffName.Selected.Mail,
      Division: lblExpDept.Text,
      'Job Title': lblExpJobTitle.Text,
      'Exemption Reason': DrpExempReason.SelectedText.Value,
      'Other Reason': txtOtherReason.Text
  }
)

however if it is now a Single Line of Text as you have noted

Patch(
   ExemptionItems,
   ThisItem,
   {
      Supervisor: lblExpSupervisor.Text,
      'Supervisor Email': lblExpSupervisorEMail.Text,
      'Staff Name': ComboStaffName.Selected.Mail,
      Ward: lblExpDept.Text,
      'Date Exemption': DateExemp.SelectedDate,
      Email: ComboStaffName.Selected.Mail,
      Division: lblExpDept.Text,
      'Job Title': lblExpJobTitle.Text,
      'Exemption Reason': DrpExempReason.SelectedText.Value,
      'Other Reason': txtOtherReason.Text
   }
)

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.

Visit my blog Practical Power Apps

[ClarkyPA365]

Hi Warren,

I'm getting so confused how this is happening and why I can't just do a simple task as to display the name selected from the ComboBox??

I've made the amendments and this is what is happening now

Added three names - Gallery is showing same information for the first name added 

But SP list is displaying the three names along with the additional information

[WarrenBelz]

Hi Chris,

Is the source for this field inside or outside the gallery? I assume it is this one

'Supervisor Email': lblExpSupervisorEMail.Text,

You are Patching ThisItem, so the reference has to be in the record in the gallery row you are sourcing the data from. I assume you are patching from inside the gallery?