Forms

PaulRobinsonFK you can't do this just with Forms on its own, and it was designed that way. But you can use another of the Office 365 apps, Power Automate, create a flow that gets the form response and then does exactly what you want. An example of one we use is shown below on the day a new startre begins in the company.

The flow is triggered to run at 14.30 every day. Then we initialize a string variable to store the new starter's company ID number. Next we add a compose to format today's date in yyyy-MM-dd format which is the required format for date comparisons.

Next we add a get items action to query the Tracker list, filtered to only bring back those where they are a starter and the start date is today (the output of the previous compose, selected from the dynamic content box that appears on the bottom right).

Because of the get items action you will need an apply to each action (even if only 1 item might be brought back). Within that apply to each I've added another Compose action to get the hiring manager's email.

Next, in our emails we always include the company logo, we we get that with a get file content using path and select the location in OneDrive where the logo image is stored.

We then add 2 more Get file content using path actions to get 2 files from another site, our HR site, which will be attached to the email.

Finally we add a send an email from a shared mailbox action to send the email with the pdf attachments to the hiring manager. You'll note that HTML tags have been used (click the </> code view button). This is because of the logo that we need to include in the email. The attachment name is added and file content is selected from the dynamic content box.

Come back with any questions about this.

Rob
Los Gallardos
Microsoft Power Automate Community Super User