Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Upload to Dataverse from sharepoint - Content is empty

Posted on 3 Dec 2024 15:47:02 by
Hi everyone,

I'm trying to create a flow that looks through a folder in sharepoint and uploads every file in it to a rows in a Dataverse table. The files in question will be word files.

I have built a very simple flow to test this but the problem I have is that, in the upload to dataverse step, the input is showing the content of the file but the output is just empty...

Anyone have any experience with this? Looking through the forum at similar topics did not really help me... A general picture of the flow is attached, if you need more information happy to provide it.

Thanks!
Categories:
  • creativeopinion Profile Picture
    creativeopinion 9,897 on 04 Dec 2024 at 00:32:37
    Upload to Dataverse from sharepoint - Content is empty
    @ri_mar It's hard to offer any recommendations without seeing your full flow and the logic behind it. Toggle off the New Designer and click each action to expand it. Upload a screenshot of your flow in edit mode.
     

    Get Files (Properties Only)

    This action returns files and folders. To filter out files only you can use the following filter query:
    FSObjType eq 0
    
    If you can share what your current query looks like, it'll help to provide more insights.
     
    Toggle On Pagination
     
    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

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.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,297

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,890

Leaderboard