Hi
... Here is a tough one for you to think about.... thought I would share since I thought about this one long and hard,
Background - These are SharePoint Lists
- I have an Account List in SharePoint
- I have a Contact List in SharePoint
- The Account list has a lookup column that lets the user add an exsiting contact from the Contacts List
- I have a Form that lets the user add a new Contact from within the Account
- I have a save button on the Account Form
When a user enters a new Account, they will likely also want to add a new Contact record at the same time So I let the user enter in the account info and also enter in the Contact Info - 2 forms - 1 to accounts and 1 to contacts
When The user hits save on account, I submit both forms ( the new account and the new Contact)
With me so far ?? 🙂
Now here is trick
I submit the Account form first then I submit the Contact form and store the Account ID in that Contact List
I want to put in that new contact into the lookup field in the account after I save the Account and Contact
I put the following Patch in the On Success of the New Contact Form I created when I eneterd in the new account
MainContactA is the lookup to Contacts in the Account List
Patch(Accounts, First(Filter(Accounts, ID = Account_New_Contact_Form.LastSubmit.AccountID)),
{MainContactA:
{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:Account_New_Contact_Form.LastSubmit.ID,
Value:Account_New_Contact_Form.LastSubmit.Title}
})
PowerApps is happy and this does save the New contact into the Contact list and the lookup in Accounts
Hope that made sense .... Very tricky stuff!
