cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Action 'list_rows_present_in_a_table' failed depends on the account

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. 

 

nick_0312_0-1639442606636.png

 

nick_0312_1-1639442262803.png

 

 

nick_0312_0-1639442002958.png

 

 

 

6 REPLIES 6
PrasadAthalye
Super User
Super User

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

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
Anonymous
Not applicable

Still not working...

Anonymous
Not applicable

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
Community Support
Community Support

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:

vbofengmsft_0-1639538595302.png

vbofengmsft_1-1639538607577.png

So we need to get the file's ID first, I've made a test for your reference:

vbofengmsft_2-1639538789456.png

The Result

vbofengmsft_3-1639538884007.png

 

Best Regards,

Bof

 

 

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

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
Anonymous
Not applicable

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?

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (3,141)