Hello Community,
Hopefully, someone can help me with a deep linking issue that I cannot seem to resolve. I have an Edit form that is connected to 2 repeating Galleries. Each Gallery has a different SharePoint list than the Edit and New forms. The creation of the New Form triggers a flow with an email that contains the link to the Edit form item, but that item is blank when the link is opened and so are the corresponding Gallery items. Screenshots and my syntax are included below. Thank you in advance for any help; I've been trying to make this work for the past three days with no luck 😞
Patti
App > OnStart >
Set(varRecord, LookUp(TestInventoryRound4, ID = Value(Param("ItemID"))));
If(!IsBlank(varRecord), EditForm(EditRoundInvoice));
If(!IsBlank(varRecord), EditPFGallery.Selected.ID);
If(!IsBlank(varRecord), EditGAGallery.Selected.ID);
StartScreen >
Switch(Param("screenname"), "editround", RoundEdit, "roundsearch", RoundInvSearch, "printround", RoundPrintPDF, "editrectangle", RectangleEdit, "rectanglesearch", RectangleInvSearch, "printrectangle", RectanglePDF, LandingScreen)
InvoiceForm (New form) >
Datasource > TestInventoryRound4
Item > varRecord
OnSuccess >
Patch(TestPFItems, ForAll(Mon002Gallery.AllItems, {PFCodeNo: lblMon165002.Text, Items002: ddItems002.Selected, Item002Price: dd002Price.Selected, ItemLBsQTY: Value(txt002LBsQTY.Text), ItemCost: Value(txt002Cost.Text), MasterID: InvoiceForm.LastSubmit.ID}));
Patch(TestPFItems, ForAll(Mon003Gallery.AllItems, {PFCodeNo: lblMon165003.Text, Items003: ddItems003.Selected, Item003Price: dd003Price.Selected, ItemLBsQTY: Value(txt003LBsQTY.Text), ItemCost: Value(txt003Cost.Text), MasterID: InvoiceForm.LastSubmit.ID}));
Patch(TestGalvanizedItems, ForAll(Mon004Gallery.AllItems, {GalCodeNo: lblMon165004.Text, AllGalItems: ddItems004.Selected, AllGalPrices: dd004Price.Selected, AllGalFittingQTY: Value(txt004LBsQTY.Text), AllGalFittingCost: Value(txt004Cost.Text), MasterID: InvoiceForm.LastSubmit.ID}));
/*Insures there is a 'last submit' record*/
Set(varRecord, InvoiceForm.LastSubmit);
EditForm(EditRoundInvoice);
If(
IsEmpty(Errors(TestInventoryRound4)),
Notify(
"Success",
NotificationType.Success
);
Navigate(RoundSuccess),
Notify(
First(Errors(TestInventoryRound4)).Message,
NotificationType.Error
)
);
ResetForm(InvoiceForm);
NewForm(InvoiceForm);
Reset(Mon002Gallery);
Reset(Mon003Gallery);
Reset(Mon004Gallery);
EditRoundInvoice (Edit form) >
Datasource > TestInventoryRound4
Item > varRecord
OnSuccess >
If(
IsEmpty(Errors(TestInventoryRound4)),
Notify(
"Success",
NotificationType.Success
);
Navigate(LandingScreen),
Notify(
First(Errors(TestInventoryRound4)).Message,
NotificationType.Error
)
);
ResetForm(EditRoundInvoice);
Reset(EditPFGallery);
Reset(EditGAGallery);
EditPFGallery >
Items > Filter(TestPFItems, MasterID = varRecord.ID)
OnSelect > false
EditGAGallery >
Items > Filter(TestGalvanizedItems, MasterID = varRecord.ID)
OnSelect > false
InvoiceForm (New form)
EditRoundInvoice (Edit form)
Email w/Link to Item

Report
All responses (
Answers (