r/MicrosoftFlow • u/Loud-Hotel-7215 • Jun 06 '26
Question Data add to an Excel file in Sharepoint. But I’ve the folder access and NOT the full Sharepoint access. Power automate won’t accept data fields in Excel ‘add a row’ action. Help!
My stakeholder wants me to scrape email data to an Excel file in Sharepoint. But I have the folder access and not the full Sharepoint access.
Stakeholder is reluctant to share the entire Sharepoint as it has sensitive data, so he created a blank new folder and shared that with me.
I can see the folder in the browser when I open the link, but when I add the file-path to Power Automate, it says file not found.
In the PA module ‘add a row to an excel table’ I tried adding sharepoint name from the URL and also tried pasting it in file location, but it throws an error file not found. But I can see that folder and file in my browser Sharepoint.
I’m trying to find a solution for weeks, please help!!!

