I have an automated flow running that creates an event booking triggered when a contact field "webform" is populated. The flow creates the event booking I want created, applying fields from the contact table but I want to link the event booking to the event, which is a separate Dynmaics custom table. I have the name of the event booked in a text field "webform" in the contact record but am stuggling to find a way to lookup this name field against the Events table and return the GUID of the Event record to write into the event booking lookup field.
I beleive I should be using Get Record but struggling to find how to apply this to my (hopefully simple) situation.
I know that the event name text field is unique and the same as the event name in the Event table as that is sorted in another process, so no danger of duplicate event names!
Can anyone point me in the right direction please?