Sharepoint List not updating data through powerApp

[Anonymous]

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

[v-siky-msft]

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

[Anonymous]

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?

[Anonymous]

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

[v-siky-msft]

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

[Anonymous]

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

[v-siky-msft]

 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

[Anonymous]

I selected as choice...for both column

[v-siky-msft]

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

[Anonymous]

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?