Answered

Cannot update SharPoint list "Title" field to original value

(0) Share

Report

Posted on by 8BitWarrior

I have an PowerApp that stored data in a SharePoint Online list. In the app I have the ability to modify all the values that I am storing in SharePoint. However, when I try to change the value of the "Title" field in SharePoint back to what was originally there, I cannot.

To modify the values I am using UpdateIf and Patch conditional statements. I am only experience the outlined issue with the default Title field in the SharePoint Online list.

Example:
Step 1 - Create a new record in SharePoint Online, setting the Title field value to "Name1"
Step 2 - Modify the record for Name1 changing the value to "Name2" (Succeeds without issue)
Step 3 - Modify the record for Name2 changing the value back to "Name1" (No changes occur)

Is this a bug or by design?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

You may have to employ a textbox to make it dynamic. With two texboxes, OldTitleTextbox and NewTitleTextbox. Then
Patch(ListName, First(Filter( ListName,Title=OldTitleTextbox.Text)), {
Title: NewTitleTextbox } )

With this type what you want to change in the OldTitleTextbox and what you want to change to in NewTitleTextbox

If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution

Was this reply helpful? Yes No
Verified answer

8BitWarrior 68 on at

Like
a
(0)

Report
Copy link

Link copied!
@eka24

Thanks for the suggestion - I did discover that the issue was with my code. In my conditional statement I had the following entered:
If( FET_Tech_Title=true&&!(Edit_Title_Change.Text exactin ThisItem.Title), UpdateIf(Requested_Technology,UniqueRequestId=SelectedRequest,{Title:Edit_Title_Change.Text}) )
Once I removed the follow code section "!(Edit_Title_Change.Text exactin ThisItem.Title)" the function worked. It appears that SharePoint always remembers what initial "Title" value is and using the exactin function will always negate your logic.

Just a cautionary tale here.

Was this reply helpful? Yes No