web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Values not updating on...
Power Apps
Unanswered

Values not updating on Sharepoint

(0) ShareShare
ReportReport
Posted on by 182

Dear community,

 

I am trying to save data from Power Apps and only 1 column is not getting saved on Sharepoint. Let me try to explain what I am doing:

 

1) I have a combobox which is basically fetching data from excel online. There will be similar drop downs and labels that will be pre-populated / auto populated basis the user selection.  For this combobox- 'Items' formula / value is "Table1.'Entity Code'". Where table 1 is the table name in excel online and Entity code is the column name which I want the user to select in the combobox.

 

2) I have a column in Sharepoint as Entity code which is a multiple "text data type". In power apps in edit forms i removed the default data card of Entity code and instead placed the combo box created in step 1 above. The 'Update' field of data card is updated to - "ComboBox1_1.Selected.'Entity Code'" and I dont get any error.

 

As soon as i fill in the values and submit save , the value for Entity code is not getting populated on Sharepoint.

 

Save button- SubmitForm(Form1_1);Navigate('Thank You Screen',ScreenTransition.Cover)

 

Could any one guide me where am I going wrong as a result only 1 data is not getting saved on Sharepoint?

Categories:
  • BrianS Profile Picture
    2,407 Super User 2024 Season 1 on at

    When you highlight the formula in the Update field, do you see a value listed under the formula bar? It should give a hint.

    Also - I would suggest moving your Navigate to the OnSuccess property of the form. That way it will not navigate away if the form has a problem - easier to trouble-shoot.PwrApps_FormulaBar.jpg

  • vaibhavtandon87 Profile Picture
    182 on at

    @BrianS  Thanks for the response!

     

    I am attaching the screenshot.

     

    update not working.png

     

    I see On success of Edit form as false, what shall I change to?

     

    The remaining values are successfully getting saved on SharePoint except this one.

     

     

  • BrianS Profile Picture
    2,407 Super User 2024 Season 1 on at

    You would just delete the Navigate command from your submit button and put that command in place of the "false"

    If your app is not showing any runtime errors, I guess we would need more info about the data. Is the field a short text field type?

  • vaibhavtandon87 Profile Picture
    182 on at

    @BrianS  Yes I am successfully able to save after changes to on success without any error though the data is not coming on Sharepoint.

     

    YEs both are text

     

    On excel online - Type is text

    On Sharepoint the field is single line of text

     

    Data type on Sharepoint.png

     

     

  • BrianS Profile Picture
    2,407 Super User 2024 Season 1 on at

    To trouble shoot further I would add a Set statement to your Submit button to save the value in a variable. See if that gets the correct value.

    How did you get the card in the form?

  • vaibhavtandon87 Profile Picture
    182 on at

    no value in variable coming.png

    @BrianS , the value in variable is not getting populated.

     

    how did i get the card in the edit form?:

     

    1) The sharepoint list has a field 'entity code'  which is to be inputted by the end user and the list of entity codes is stored on excel online sheet table. In the edit form I got the field Entity code by default but I deleted the datacard from that.

    2) I created a combo box with Items property formula - Table1.'Entity Code' and placed the Combo box inside the bigger Entity code card in edit form. I replaced the update formula of entity code card property with - ComboBox1_1.Selected.'Entity Code'

  • BrianS Profile Picture
    2,407 Super User 2024 Season 1 on at

    Sorry - I missed this earlier. I think the problem is that you are using a Combo box. That results in a record. Try replacing that with a dropdown using the same formulas and see if that works. You may need to change the Update to Dropdown.Selected.Value

  • vaibhavtandon87 Profile Picture
    182 on at

    Hi @BrianS ,

     

    Thanks for the response!

     

    I did try using dropdown after your suggestion but that doesnt work as well 😞

     

    Also my requirement is to have Combobox as the list is ~5000 items and user want a search option to search for the code.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 393 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 278 Most Valuable Professional

Last 30 days Overall leaderboard