I've created a canvas app, and through the connection I can see a lot of tables. When I use the exact same connection with the same credentials in a cloud flow, I only see a few tables. I have permissions to read all the tables, and the tables I see in the cloud flow are random. There is no reason why I would see these specific tables and not the others.
Are you saying that you have access on the table from SQL but those tables in not listed in dropdown in any of the actions that you use in Power Automate?
Did you tried searching? I mean example: Lets say there is table named "TEST" which you are not able to see when you use an action in Power Automate lets say "Add Record" Then try typing "TEST" and see the table appear as result.
Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
Thanks, ANB
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.