Unanswered

Title field in SharePoint loses value after edit

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I have a customized SP List using PowerApps and i have somewhat of a strange issue happening. After submitting a form the title field in SharePoint List gets a concatenated value from 2 lookup fields within my PowerApp. Like the screenshot below.

After Saving, the line item in the list it looks like this. Where the title field concatenates the WFS Account and Existing Site Url fields

After opening the item and just clicking on edit all (making no changes, just clicking edit and save). The title field becomes blank although there is still both values within the list? I am tryign to figure out why that title field goes blank.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Check the Update property of the Title card and see if it reflects what you want to happen.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I think it might be here. This is the default for the Title Data Card Value
If(ExistingAccountToggle.Value,Concatenate(DataCardValue3.Text," ","-"," ",DataCardValue12.Text),Concatenate(WFSAccount.Selected.Name," ","-"," ",WFSAccount.Selected.SalesForceID))

On update the Title_Datacard1 is set to DataCardValue1.Text
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

With({toggleon:If(ExistingAccountToggle.Value, Concatenate(DataCardValue3.Text," ","-"," ",DataCardValue12.Text), Concatenate(WFSAccount.Selected.Name," ","-"," ",WFSAccount.Selected.SalesForceID) )}, Coalesce(Parent.Default,toggleon) )

If you put the formula above in the Default property of DataCardValue1.Text then when the form is in New Mode, it will show the first concatenation formula if the toggle is on and the second concatenation formula if the toggle is off.

When the Form is in Edit mode, it will show the previously chosen data. I am not sure that is what you wish but if not, please specify the result you want. In either case, you may wish to disable the card so that the user can't change it as I am inferring from your formula that the result is calculated either way and does not require input into DataCardValue1.