Skip to main content

Notifications

Community site session details

Community site session details

Session Id : eodnhP87VVLq72uwN1Qy49
Power Automate - Building Flows
Unanswered

Flow Twitter to Azure Blob as JSON file - Help

Like (0) ShareShare
ReportReport
Posted on 22 Oct 2016 01:20:26 by

Want to create a flow to create a BLOB file in JSON format for every tweet that contains a hashtag.

 

I've built the container in Azure Blob, connected successfully.  I've picked: twitterID as the blog file name.  I want tweetedBy and tweetText as the JSON file contents.

 

It works, but the files are in text with no formatting at all.  Worse, they have /n or line breaks.  A mess.  

 

I figured the twitter input would be serialized as JSON and thusly the Azure blob output would then be JSON.

 

No?  What am i doing wrong?

  • Community Power Platform Member Profile Picture
    on 24 Oct 2016 at 14:08:36
    Re: Flow Twitter to Azure Blob as JSON file - Help

    @v-monli-msft Thanks.  Yes, your picture describes exactly what I'm doing - that is:  trigger on tweet, action; write blob to Azure blob storage.  The only small difference is that I'm writing to a \Tweets folder in my blob container.

     

    The Flow works fine.  The blob file gets written in the \Tweets folder upon each tweet.

     

    The problem is that the blob file is not in JSON format.  It's in TXT, with no separation between TweetedBy and TweetText.  It has carriage returns.

     

     

    When I extract my blobs from the azure storage container, it's essentially unusable, jumbled mess.

     

     

    It seems Flow is missing a "how to format/serialize output?" feature.

     

    Eric.

  • v-monli-msft Profile Picture
    on 24 Oct 2016 at 06:56:54
    Re: Flow Twitter to Azure Blob as JSON file - Help

    Reply:

     

    Hi Evogelpohl,

     

    Is the trigger of this flow “when a new tweet is posted”? If so, you could try to change another trigger to have a test, just to see if this is only happening to tweet parameter.

     

    In addition, is your flow one like below?

     Capture.PNG

    Regards,

    Mona Li

     

     

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 368 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 300 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 299

Overall leaderboard
Loading complete