Unanswered

Editable Table with ComboBox and AutoSave functionality

(0) Share

Report

Posted on by MikeLockwood

197

So I have been working on creating an Editable Table that has Comboboxes for currency selection and should auto save the record once a change happens. The data store is SharePoint and instead of using Choice fields in SharePoint I created them as text to eliminate the need for patching complex types back to SharePoint (such a pain). Now I load a collection on screen load that say has a few numeric fields for dollar amounts, a title field and then my text currency field. On the combobox change event I patch the collection with the selected value. For the first item in the collection this works fine. For the next or any other item it defaults to the values of the dropdown in the first item. This just does not make any sense, Hoping someone can explain this functionality.

I played around with the information in this post but it is writing back a complex type as opposed to just a string.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MikeLockwood ,
Do you want to update by a combo box?
Could you show me your formulas or pictures?
As far as I know, the problem that you met is related to the setting of OnChange.
Try this formula:
Patch(Tbl,LookUp(Tbl,key=ThisItem.key),{currency: ComboBox_choice.Selected.currency})
What's more, as the post that you shown used a choice column as example, you need to change all the settings about it to text type.

Best regards,
Community Support Team _ Phoebe Liu

Was this reply helpful? Yes No
MikeLockwood 197 on at

Like
a
(0)

Report
Copy link

Link copied!

Here are the images of the 3 main controls. Now i have found that if i do this with a plan table in a collection it seems to be working. If i am using a SharePoint List to populate the collection then I seem to have the issues discribed in the original post.

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MikeLockwood ,
Could you describlr more clearly about "the issues discribed in the original post"?
It will be better if you could show me the screenshots about it.
Is picture1 a plan table in a collection?
How do you use a SharePoint List to populate the collection?
What are the two collections' differences, especially the data type?

Best regards,
Community Support Team _ Phoebe Liu

Was this reply helpful? Yes No
MikeLockwood 197 on at

Like
a
(0)

Report
Copy link

Link copied!

Phoebe Liu sorry it has taken me a bit to get back to you.

So in my pictures I am using ClearConnect to pull data in from a SharePoint list, so CIPQuestionnairre List is a SharePointList. The KhalixValuesList is also a SharePoint list. The issue is only when I am using a ComboBox, which is the second image, inside of a gallery thats items are colEnteredCIPValue (sharepointlist). The is one ComboBox an 4 text fields. I have the same type of functionality in the textboxes where on change they upate the collection, no issues. For the combobox it it works fine for the first item in the list, updates the collection. The problem is the rest of the items. If I change the value of the combobox on the second item, it changes to the selected value for a split second and then gets set to the value of the combobox of the first item in the collection. Now if i change the same item again it will stick. So I can do the same thing but if I use a basic table as in the example I linked to in the original post it works fine. So it seems that this is an issue with the SharePoint List but I cant figure it out.

Was this reply helpful? Yes No