I have created below two SharePoint lists:
Customer Info: CustomerName(Title), CustomerID, ContactNumber, Country
Product Info: Title, Customer, CustID, Price
I have added Gallery and EditForm controls on the same screen and connected to 'CustomerInfo' SharePoint list as a data source.
Using the 'AddColumns' function I have added a new column to the result in Gallery control and I have set the result to new label control Refer my previous post here.
Fyi.. I am fetching the Price value from ProductInfo list.
In Button OnSelect property, SubmitForm(Form2_1) is updating the record in CustomerInfo list since it is the main source which is connected as data source.
But I also need to update the Price value in ProductInfo list which is the main source of this field.
SubmitForm(Form2_1); Patch( ProductInfo, If( FormMode = "New", Defaults('ProductInfo'), LookUp( ProdColll, CustID = DataCardValue2_1.Text ) ), {Price: DataCardValue5_1.Text} );
Here:
ProductInfo: Is the list where i wanted to update the Price field value.
Defaults(ProductInfo): This will create the new record if the formmode is New.
In Lookup: From the collection(ProdColll), I am comparing the CustID value and updating the datacard value in Price field.
No comments:
Post a Comment