cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (74,768)