I create one flow that is getting a json date from power app and adding the date to excel on sharepoint.
But I have a problem with an account that has added as a guest from external of organization.
This flow works not problem with internal account. Is this error related with some of permissions that the guest account doesn't have?
There are some other sharepoint/excel operation exist (like Get ID, Get files) in the same flow but only this action is failing. And I'm sure the table named "Timesheet" is exist and variable "FullPath" and FileName" are correctly set because this action is passing from internal accounts. (Confirmed that the flow sends same request for both internal/guest accounts)
Where is the excel file located? Does external User has access to that location and required permissions?
Hi Parasad, thank you for your advise.
The excel is located on sharepoint and the external user has access and write permission... if you have any ideas, please let me know...
Hi @Anonymous :
The key is that the file parameter requires the ID of the file instead of the path. You could check its actual input through the peek code function:
So we need to get the file's ID first, I've made a test for your reference:
Are you creating excel as part of the flow or its already available in SharePoint?
Thank you Prasad, v-bofeng-msft for both your reply.
Yes, in the flow before the list_rows_present_in_a_table, creating the base excel file if it not exist in the sharepoint folder. But I confirmed that input to the "list_rows_present_in_a_table" are completely same from both Guest and internal user. So I don't think file selection itself has any problems but somehow depends on the user type, my flow is rejecting the list rows request.
Is there any permission setting required other than sharepoint? specifically for flow?
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.