Values not updating on Sharepoint

(0) Share

Report

Posted on by vaibhavtandon87

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:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
vaibhavtandon87 182 on at

Like (0)

Report

@BrianS Thanks for the response!

I am attaching the screenshot.

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.

Was this reply helpful? Yes No
BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
vaibhavtandon87 182 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
vaibhavtandon87 182 on at

Like (0)

Report

@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'

Was this reply helpful? Yes No
BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
vaibhavtandon87 182 on at

Like (0)

Report

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.

Was this reply helpful? Yes No