Unanswered

value of sharepoint list item gets blank when form is edited using power app

(0) Share

Report

Posted on by Tejaswini1234

150

sharepoint form is customized and added azure sql column values in drop down list, i used combo box in which values gets filtered according to drop down list, values in combo box gets from azure sql ,

when sharepoint form is edited , value gets blank.

combo box defaultselecteditem

If(
SharePointForm1.Mode = FormMode.Edit,
{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Value: ThisItem.'Vendors Name'
}
)

combo box item property

Search('[dbo].[vw_FlowAutomation_Vendors]_1',DataCardValue3.Selected.Value,"Company")

when combo box is selected its associated address field value should be display in text box,,

but its value is saved in sharepoint list but not shown in edit form ?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Tejaswini1234 ,

Firstly, a custom sharepoint form is just a form, not a powerapps app.

These two are different.

Could you describe more clearly about your problem?

Do you mean that the combo box in sharepoint custom form can not display value?

If you could show me your form's screenshoots, it will be better to understand your issue.

Was this reply helpful? Yes No
Tejaswini1234 150 on at

Like
a
(0)

Report
Copy link

Link copied!

in took vendor and address column which is sinngle line of text in sharepoint when its customized,, in vendor name datacard i put combo box and assign azure sql table column values, when combo box vendor value get selected its related address should be display in textbox field of address,
while editing sharepoint list item form, that time address field gets blank

Was this reply helpful? Yes No
Tejaswini1234 150 on at

Like
a
(0)

Report
Copy link

Link copied!

while changing the combo box values it address in textbox field should be change in edit form of sharepoint list item

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Tejaswini1234 ,

Could you show me the settings of the textinput control, especially the default property?

Was this reply helpful? Yes No
Tejaswini1234 150 on at

Like
a
(0)

Report
Copy link

Link copied!

PlainText(
If(
SharePointForm1.Mode = FormMode.Edit And TextInput4.Text = DataCardValue6.Text,
ComboBox2.Selected.'Formatted Address',
SharePointForm1.Mode = FormMode.Edit And IsBlank(DataCardValue6.Text),
Parent.Default,
SharePointForm1.Mode = FormMode.Edit And DataCardValue6.Text <> TextInput4.Text,
ComboBox2.Selected.'Formatted Address',
ComboBox2.Selected.'Formatted Address'
)
)

There is company drop down list , vendor combobox and address textbox on form,
when company seleceted , its vendors get filter in combobox and address in textbox on form,
In edit form when company is changed ,its defaultselected item is not remove from vendor combo box as it is not present in that form,

Was this reply helpful? Yes No