im currently building an application that allows the users to apply for jobs, when they click submit I have it set so it sends an email with the function that I have included as an image.
however, is it possible to have powerapps search the sql database im using as the data source for email addresses linked to that particuar job and send the email to THAT selected address rather than the preset one in the function.
I'm sure this is possible but I don't understand which email you want to send and where its located in your database. Could you please explain a little bit more about the underlying data?
hi, sorry for the confusion,
basically at the moment ive put my email address in the function so when the user clicks apply on the job it sends am email with the job title their name etc.
each job in the database has a different email for the manager of that copany so when the user clicks apply the app searches for the job in the database sees the email address corresponding to that job and sends the email to them.
I hope this helps. again sorry for the vagueness
I assume there is a form displaying the current job on your screen. Could you replace your own email...
...with a reference to the job email showing on the form?
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."