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.
1 Like