Additionally, the default limit of files returned by the Get Files (properties only) action is 100. You will need to toggle on pagination. Click on the three dots of the Get Files (properties only) action. Select Settings.
Toggle on pagination and set a threshold. Scroll down and press done. Keep in mind that retrieving a large number of items can slow down your flow significantly. It’s always better to filter results as much as possible to minimize the number of items retrieved.
Return Count of Items
Whenever I use a Filter Query in a Get Items action, I always like to return the count of items returned in a Compose action. This is helpful when building a flow and can also be used to troubleshoot your flow.
Insert a
Compose action. Add an Expression. Use the
length() function.
Select the Dynamic content tab and insert the value dynamic content from the Get Items action into the length() function.
Run a test.
Condition Check
Add a Condition action to your flow. If items have returned (aka there is number stored in the Compose action—that is not equal to 0), add the rest of your actions to the Yes branch. If not, do nothing.
It's unclear why you want to upload a file to dataverse. Would the file be edited at any point in time. If so, have you considered maybe including a link to the file on SharePoint instead of the content?
Hope this helps!
Consider giving me a
❤️ if you liked my response!
👉 Level up your Power Automate skills by checking out my tutorials on
YouTube
👉 Tips and Tricks on
TikTok and
Instagram