Answered

Sharepoint List not updating data through powerApp

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have created power app through my SharePoint list. But, I have changed some formula in the data card value. When I am updating and submitting my Powerapps form, data is not updating in SharePoint List for those edited data card value.

Regards,

Bhavuk

Categories:

Building Power Apps

Powerappscreen.PNG

Sharepoint LIST.PNG

I have the same question (0)

All responses (18)

Answers (2)

v-siky-msft on at

Like (0)

Report
Hi @Anonymous ,

What is the type of Select Country column? LookUp type?
If the Select Country column lookup to the Country column of Table1 list, you should modify the Update property of Datacard as below:
{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: LookUp(Table1, Country = ComboBoxName.Selected.Result, ID), Value: ComboBoxName.Selected.Result }
Hope this helps.
Sik

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi,

App is created through SharePoint List. So it's automatically shows coulumn type item =Choices([@'New Form'].Column Name). I have done changes tin the formula item with one drive file and gave filter on the basis of select item. Afterwards, I am able to save data in powerapp, but my edit formula column is not updating in SharePoint List

is this info is sufficient for you?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi,

App is created through SharePoint List. So it's automatically shows column type Item =Choices([@'New Form'].Column Name). I have done changes tin the formula item with one drive file and gave filter on the basis of select item= Distinct(Filter(Table1,Country=DataCardValue19.Selected.Result),Site) Afterwards, I am able to save data in powerapp, but my edit formula column is not updating in SharePoint List

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report

Hi @Anonymous ,

OK, I believe the issue is from Update property of Data Card.
Could you please share the Update property of 'Select Country' column?
And what is the column type of 'Select Country' column? Please go to List Setting to show the column construct.
Sik

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Sik,

yes, you are right it's an issue to update property of data card.

update column = DataCardValue.Selected

And , I have also another column. I have deleted auto created column and created new column through blank with drop down option. Now the formula on update it's showing error.

I have attached screen shot for you.. thanks

site.PNG

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report

and Hi @Anonymous ,

OK, but you still haven't answered my question concerned about most.
Please go to SharePoint list- List Setting to show the Column and Type of 'Select Country' and Site.
I need to know the column type and then provide the proper code to resolve your issue.
Sik

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I selected as choice...for both column

share.PNG

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report

Hi @Anonymous ,

Since both columns are Choices type columns, they can only save the given choice.
Please make sure that the values in the Country and Site column in table1 are all from those choices.
If the above conditions are met, please try to modify the Update property of two data cards as below:
1. Select Country Data Card:
LookUp(Choices([@'New Form'].'Select Country'), Value=DataCardValue19.Selected.Result)
2. Site Data Card:
LookUp(Choices([@'New Form'].Site), Value=Dropdown2.Selected.Result)

If the values are not limited to the given choices, you have to add each kind of values to the Choices list, and refresh the SharePoint list connections, then try the above workaround.
Hope this helps.
Sik

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Sik,

thanks for the update.

Actually scenario is to auto fill another column on the basis of selection first column... For an example if country is UAE, auto fill the value in site column Dubai. That's why I have changed the formula in the column and my second connector from One drive excel file.

To complete my scenario, I have put formula in
Country Column = Sort(Distinct(Table1,Country),Result)
Site Column = Distinct(Filter(Table1,Country=Country datacardvalue.Selected.Result),Site)
After this, I am looking how to update this in my share point list. Do, I need to make column as single line text in SP list?
Or is there any way to achieve the scenario?

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (1)

Report
Hi @Anonymous

I can see your purpose, my last post has mentioned about how to achieve this.

First, make sure that the values you get from the table1 are in choice value.
For example, 'Select Country' choice values are 'Qatar', 'UAE' and 'Bahrain', so all country values in Table1 can only be these three. If they are beyond these three values, you need to add the new country value to the Choices value in 'Select Country' column.
Second, modify the Update property of two data cards as below:
1. 'Select Country' Data Card Update property:

LookUp(Choices([@'New Form'].'Select Country'), Value=DataCardValue19.Selected.Result)

2. Site Data Card Update property

LookUp(Choices([@'New Form'].Site), Value=Dropdown2.Selected.Result)

Hope this helps.
Sik

Was this reply helpful? Yes No