Forum Discussion
How to remove and add the fields in the Items Properties in Sharepoint?
- Aug 17, 2022
Holly-CMS You cannot update the value of SharePoint default Title column using formula.
My suggestion is modify formula in Power Apps to update the Title column same as how you are updating the ITRequestID column now. This will be the best approach to follow.If you cannot modify power apps for any reasons, you can create a power automate flow which will run on item creation/update (trigger - when item is created or modified) with single "Update item" action - you can use this action to populate Title column value based on ITRequestID column.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
With that said, the title in the Sharepoint list is not populating and is hidden. It auto populates the value in the ITRequestID column.
I can unhide the title in the list. However, I would need to copy the value from ITRequestID to the Title in order for the ITRequestID values to show up in the Item Properties.
How do I do that? I see power automate but I am hoping for a formula that can be done in the List that can pull it into the Title column?
Holly-CMS You cannot update the value of SharePoint default Title column using formula.
My suggestion is modify formula in Power Apps to update the Title column same as how you are updating the ITRequestID column now. This will be the best approach to follow.
If you cannot modify power apps for any reasons, you can create a power automate flow which will run on item creation/update (trigger - when item is created or modified) with single "Update item" action - you can use this action to populate Title column value based on ITRequestID column.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- Holly-CMSAug 17, 2022Copper ContributorDid the power automate and it worked beautifully!!!!! Thank you!!