Answered

Field value not saved

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I have a Edit form in the edit/new screen. I changed the datasource for one of the fields, combobox (getting data from another list, and filter the results ( eg: Filter(ListMarketProducts, Title = DataCardValue13.Selected.Value)). I see the relevant results, but the problem is that the selected value is never saved in the list (I got empty value, and all other fields are saved). In the formula field for the buton that supposed to trigger the save event I have "SubmitForm(EditForm1)". I tried also "Collect(ServiceList, { ..., Products: DataCardValue1.Selected})", but the same problem, the Product field is never saved. What could be the issue?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
The UPDATE property of a Card is the property that controls what gets inserted into the database on submit.

Suggest you share a screenshot of your app, share any relevant code and more info about your datasource (what data type is the column you are saving into? What does each table look like, etc?) That will make it easier for someone to respond to your question.

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

Like
a
(3)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about the Products field in your SP List? Is it a Text type column, Choice type column or a LookUp type column?

1. If the Products field is a Text type column

Set the Update property of the Products Data card within your Edit form to following:

DataCardValue1.Selected.ColumnName // ColumnName represents the column in your another list, which you want to save its value back to your Main SP List

2. If the Products field is a Choice type column:

Set the Update property of the Products Data card within your Edit form to following:

{ Value: DataCardValue1.Selected.ColumnName }

If you have enabled "Allow Multiple selections" for this Choice type column, please consider modify above formula as below:

ForAll( DataCardValue1.SelectedItems, { Value: ColumnName } )

3. If the Products field is a LookUp type column, which reference values from your another ListMarketProducts list:

Set the Update property of the Products Data card within your Edit form to following:

{ Id: LookUp(ListMarketProducts, ReferencedColumn = DataCardValue1.Selected.ReferencedColumn, ID), Value: DataCardValue1.Selected.ColumnName }

I assume that the Products field references values from the ReferencedColumn in your ListMarketProducts list.

If you have enabled "Allow Multiple selections" for this Choice type column, please modify above formula as below:

ForAll( RenameColumns(DataCardValue1.SelectedItems, "ReferencedColumn", "ReferencedColumn1"), { Id: LookUp(ListMarketProducts, ReferencedColumn = ReferencedColumn1, ID), Value: ReferencedColumn1 } )

Please consider take a try with above solution, then check if the issue is solved.

More details about the ForAll function, please check the following article:

ForAll function

Best regards,

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

Like
a
(0)

Report
Copy link

Link copied!

Hi all,

Product is a choice field, single value - in the form: DataCardValue1.
I changed the datasource, from original to:
Filter(ServiceListMarketProducts, Title = DataCardValue13.Selected.Value)
ServiceListMarketProducts - another sharepoint list, DataCardValue13 - another combo box from the app, user for filtering.

I added the Product field again to the editform, and I set the default to this (for selecting the same value as DataCardValue1):
{ Value: DataCardValue1.Selected.Market }

Don't know if it's best solution or not, but it's working (add and update).

Thanks!

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(3)

Report
Copy link

Link copied!
Hi @Anonymous ,

Have you taken a try with the solution I provided above?

Based on the needs that you mentioned, I think the solution I provided above could achieve your needs. Could you please share a bit more about the "I added the Product field again to the editform", what do you mean? Do you add two Product fields (Choice field) into your Edit form? I do not think it is possible, the fields within the Edit form is unique.

Please consider set the Update property of the Product field data card (in your Edit form) which contains the DataCardValue1 to following:

{ Value: DataCardValue1.Selected.Market }

Please take a try with above solution, then submit your Form data, check if the ComboBox value (DataCardValue1) is saved back to your SP List.

If you want the saved value to be displayed within the DataCardValue1 when you edit the existing record, please consider set the DefaultSelectedItems property of the DataCardValue1 to following:

{ Market: ThisItem.Products.Value }

Note: I assume that you use the "Market" field as Display field within the DataCardValue1.

In addition, if you want to set default value within the DataCardValue2, please consider take a try with the following workaround:

Set the DefaultSelectedItems property of the DataCardValue2 to following:

{ Value: DataCardValue1.Selected.Market }

Please make sure the selected value within your DataCardValue1 is also exietd within the Products field available options from the 'AvtServiceLeads' data source. If not, the selected value from the DataCardValue1 would not be picked up within the DataCardValue2 as selected option.

Best regards,

Was this reply helpful? Yes No
ellebovell 3 on at

Like
a
(0)

Report
Copy link

Link copied!

This worked for me but I had to use:
{
Value:DataCardValue18.Selected.Result
}

The Items for my choice list was SortByColumns(Distinct('Users', User),"Result")

Was this reply helpful? Yes No