I think I found a bug in the List Rows Present In Table step. I have 5 files hosted on a SharePoint site yet when configuring this step it only shows me the first 4 alphabetically and does not show a scroll bar on the right hand side. I figured this out when I only saw that the same four files which appeared in the picker were also the first four files when I order my files A-Z in SharePoint. When I renamed the fifth file and added a "1" to the front of the name in order to place it first alphabetically. The file showed up in the picker in a matter of seconds.
How can we fix this so that I can see all my files in the file picker?
I checked and confirmed that this is not replicable in-house, with two different tenants hosted in different region. If you are noticing this behavior, you might want to open a support ticket to address this issue for more clarity.
Tenant 1 - Default environment(can view 6 Excel files)
Tenant 2- Default environment(can view 5 Excel files)
Tenant 1 was with Edge
Tenant 2 was with Chrome(incognito mode)
Also, you might want to check the same with other users in your team as well, to be sure if this is browser-user specific, or org specific issue. This would help isolating the cause.
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.