Reply To: Adding Uploaded Excel sheet from a submitted Form to Power Automate – Send Email

  • Angela Holland

    Member
    August 8, 2023 at 10:51 am
    Up
    0
    Down
    ::

    We were able to figure this out….

    Another user created the form (he did not create a “Group” form). So the file that we were uploading to the form was going to into his One Drive, because he created the form. Forms creates a folder inside the persons that created the form One Drive. Since I didn’t have access to his One Drive, I couldn’t pull the spreadsheet from the Power Automate email notification (no access error). We recreated the form under a Group group, which I do have access to and linked that form to the Power Automation instead and was able to access the file uploaded to the form. In short:

    If the user that is trying to access the file in the form (or the email link from the Power Automate email notification) has access to either the personal One Drive folder (of the user that created the form) or the Groups Shared Drive (if the form is created as a Group Form), then they can access the file that is uploaded to the form.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!