Action 'list_rows_present_in_a_table' failed depends on the account

[Anonymous]

Hello, 

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)

Please advise. 

[PrasadAthalye]

Where is the excel file located? Does external User has access to that location and required permissions?

[Anonymous]

Still not working...

[Anonymous]

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

[v-bofeng-msft]

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:

The Result

Best Regards,

Bof

[PrasadAthalye]

Are you creating excel as part of the flow or its already available in SharePoint?

[Anonymous]

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?