Creator & Flow - Fetching a lookup record.

Creator & Flow - Fetching a lookup record.

Hi,

I have a simple Creator application that has a customer and order table, there's a lookup on the order form to the customer form and I'm trying to create a flow so when an order is created it then fetches the customers email address and passes it to campaign to trigger a marketing world flow. However I'm struggling to config the fetch record to pull the customer email address with it being a lookup of the from the Order. Any assistance or guidance would be massively appreciated!

Thanks, Jake
    Zoho Marketing Automation
      Zoho Mail - CRM Integration

              Zoho Pagesense Resources

                Zoho SalesIQ Resources



                      Zoho TeamInbox Resources

                        Zoho DataPrep Resources



                          Zoho CRM Plus Resources

                            Zoho Books Resources


                              Zoho Subscriptions Resources

                                Zoho Desk Resources

                                  Zoho Projects Resources


                                    Zoho Sprints Resources


                                      Qntrl Resources


                                        Zoho Creator Resources


                                          Zoho WorkDrive Resources




                                              Zoho Campaigns Resources

                                                Zoho CRM Resources

                                                        Design. Discuss. Deliver.

                                                        Create visually engaging stories with Zoho Show.

                                                        Get Started Now