cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kharina
Helper V
Helper V

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

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


}))

kharina_0-1606287407053.png

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
ganeshsanap
Super User
Super User

@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 ‌‌👍

 

View solution in original post

2 REPLIES 2
ganeshsanap
Super User
Super User

@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 ‌‌👍

 

View solution in original post

Dear @ganeshsanap ,

 

Thank you for the sources. 

 

Kind Regards,

Kharina

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,098)