My Formula stopped working after changing an item column in SharePoint List from Single Line of Text to Person

[kharina]

Dear PowerApps, 

Can you help me to find out why did my formula stopped working? 

My formula is this:

ForAll(LS,
Patch(LRTestDbase,Defaults(LRTestDbase),
{ Notes:LS[@Notes], StartD:LS[@StartD], EndD:LS[@EndD], Dtype:LS[@DType], Totalhrs:LS[@Totalhrs],
LeaveType:Dropdown1.SelectedText.Value,EmployeeName:Label12

}))

Today, I changed the EmployeeName column in Sharepoint list from 'single line of text'  type to  'Person' type. 

This formula won't give me any error- but it just stopped patching the Employee Name field from PowerApps to the SharePoint List. 😞

Can someone please help me?

Thank You and Kind Regards,

Kharina

[ganeshsanap · Accepted solution]

@kharina 

This is happening because single line of text and person fields works differently in SharePoint.

First of all Refresh your SharePoint data source.

Then you need to change your formula according to person field. check below articles on how to patch person field in SharePoint list:

1. https://powerusers.microsoft.com/t5/Building-Power-Apps/Person-or-group-field-in-PowerApps/td-p/6741...
2. https://powerusers.microsoft.com/t5/Building-Power-Apps/Saving-data-from-powerapps-to-SP-lists-perso...

---

Please click Accept as solution if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

[kharina]

Dear @ganeshsanap ,

Thank you for the sources. 

Kind Regards,

Kharina