Get image to Twitter

[Ironiclife]

Hi,
I'm new to coding and formulas and such. I'm trying to build a flow that takes images from either Google drive or Dropbox (whichever is easier) and move it to sheets, then use sheets to schedule a post everyday at a certain time.

Right now I have (not code, just steps):
Schedule
Get rows>file= drive, worksheet= "outbound"
{Apply to each
Output= records value
Post tweet> message= "message out", media ="pic out"}

This is successful until I try to pull an image from Dropbox to sheets.

I have a separate flow for that right now:
Trigger= Dropbox when file of created
Sheets= insert row
It runs successful, but only returns the powerid thing, so I have 50+ rows of strengths like 0cb88d22cbc54413bd9919c9c07a5bff.

My ultimate goal would be to have pics that I save to a specific folder automatically get sent to sheets or wherever to form a tweet with mentions and hashtags with the capability of adding a comment to the message specific to certain pics.

Until I get the automation going, I'm using hootsuite, but I have to manually put in each picture (which means navigating to drive, then base folder, then, subfolder choose pic I haven't used yet, select, then go to homepage, find same pic, move from one subfolder ("not used") to another ("used")), paste the hashtags, add the comment, select day, select same time for each day, repeat.

I also have a sheet and form to organize and edit, such as a list of the pics with a (hopefully valid) formula to check for repeats, and join together message, mention, and hashtags.

Sorry for long post.
Thanks

[efialttes]

Hi!

Nice project.

LEt's start with the basics. Can you share a sceenshot from your current flow design? And, the Google sheets structure you are working with?

Thanx!

[yashag2255]

Hi @Ironiclife 

I believe there is no direct way to mention someone on a tweet from Power Automate. You might want to check this post on how to do it with a work around: https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/OAuth-1-0-Connection-Post-Tweets-w...

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Ironiclife]

here's the flow from dropbox to sheets to twitter

and here's the sheet 

[efialttes]

Hi!

So you are storing the image content in your google sheet...

Did you considered storing in your google sheet the File path/File identifier instead? Now, whenever you need to post your tweet message, just need to 'Get file content' by using File path / File identifier and inject its outputs

The approach I am suggesting is similar to the one explained here with Sharepoint

https://powerusers.microsoft.com/t5/Building-Flows/Post-to-Twitter-with-an-Image/td-p/84671

Hope this helps

[Ironiclife]

I gave that a try, except sending it to an email instead of twitter just in case it didn't come out right plus tweets need message (or at least I want it to have one). When I get it to run successfully, the email I get contains an attachment that has a file type as just "file" and can't be opened.

Also, would this show a different pic each time?