Hi all,
Hope it's OK to post this here - having invested way too many hours into this and making little progress I'm getting desperate so I figure it time to reach out for help!
I create a new Microsoft Form for every webinar I run (I need to use Forms so it's public and I don't have to worry about permissions etc), where I collect basic info from prospects who wish to register.
E.g. https://forms.microsoft.com/Pages/ResponsePage.aspx?id=d4ShEDPVzU6njZFtvYSdfAc7ryZFx25Bsg5e4fdw1CpURVg5WEJaM0EzT1hJNTE3NTZJVElOTjg3SS4u
I currently have lists in Sharepoint for:
- Registrations (which the form updates OK)
- Sessions (a list I enter manually of the specific webinar info like title and start date etc.)
- Email content (the email content for confirmations, reminders and follow-ups after the event)
I have one flow which works fine to write the registrant info to Sharepoint (Registrations) as they complete the form (super advanced I know :)).
What I'm trying to do now is create another flow that says, when this Sharepoint list is updated, pull registrant information, as well as specific information such as start and end date from a different list (Sessions) and use that to create an email confirmation (with an ICS file attached.)
The ICS file I hope I can somehow manage thanks to April Dunnam's great video but I can't even get to that point yet!
Where I lack understanding is the concept of how I get my flow to know which session it is I'm wanting to reference - I think I'm basically after help knowing how to reference two lists which are completely independent essentially!
Or maybe I'm going about this totally wrong?
I have 14 of these webinars planned and was hoping to make something that would scale and save me lots of manual work. So far that's not the case!! 😄
I think I've probably bitten off more than I can chew here but if anyone is able to shed any light or help with reading materials I'd be massively grateful!!
Thanks,
James
