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
Memorable Member
Memorable Member

@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
Memorable Member
Memorable Member

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

 

Dear @ganeshsanap ,

 

Thank you for the sources. 

 

Kind Regards,

Kharina

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,447)