Hi all! I am really struggling here!
I have a custom Canvas Power App/Form linked to a SharePoint document library ("Invoices Library") as the data source. I created, from the "Integrate/custom PowerApps" in SharePoint, a form to tag the document. On the form, I use lookup formulas to default certain tags to values stored on the SharePoint list ("Vendor"). When I select the Vendor Name on the library form, other fields, such as Method of Payment, Sensitivity, Account Number, etc. populate the form. Things to note, the library and list are on different sites. Vendors Name is MMD (managed metadata). Method of Payment, Sensitivity Label are Choice fields and Account number is a Text field. As an example, I'll use Method of Payment. This works perfectly UNLESS my user changes the value (overrides the value with a different value from the SharePoint library). The value writes (patches) back to the SharePoint list but if the user opens the form again, it defaults back to the value on the list. Therefore, if they changed it, they have to remember to change it again. I thought this had something to do with the form mode (New, Edit, View) but I've tried changing them and have had no luck. What am I doing wrong?
On the app:
Vendor Name
Items: Choices([@InvoicesLibrary].'Vendor Name')
VendorDocType:
Items: Choices([@InvoicesLibrary].'Vendor Doc Type')
Default: Parent.Defualt (which is Invoice)
Method of Payment
Items: Choices([@InvoicesLibrary].'Method of Payment')
DefaultSelectedItems:
If(
VendorDocType.Selected.Value = "Invoice",
(LookUp(
Vendor,
'Vendor Name' = VendorName.Selected.Label,
{Value: 'Method of Payment'}
))
)
