Unanswered

The excel table doesn't collect data from Instagram comments

(0) Share

Report

Posted on by aroe48

Hello I created a flow to collect the comments on my instagram posts. I made an excel sheet that has a table with 5 columns named : link, caption, comment, username, full_name. When I post a new photo on instagram, the flow runs and the excel file changes but all the columns remain empty except one column named "_powerAppsID_" that is automatically created and filled by Microsoft flow. I added screenshots to my flows below. I don’t know what I'm doing, any help is appreciated. Thanks

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ aroe48,

Could you please share the full screenshots of the run history of the “get comments for media” action and “insert row” action?
I have made a test on my side and don't have the issue that you mentioned.

Please check if you have created another flow to delete the row in a schedule time.

My flow's configuration as below:

When I load a new media, the flow would run successfully as below:

The rows would be inserted to the google sheet as below:

Regards,
Alice Zhang

Was this reply helpful? Yes No
fsheikh 6 on at

Like (0)

Report
Copy link

Link copied!

I have tried out the steps below and it works well, the only issue is that the flow only scrapes 1st day of comments on a post. Is there a way to to scrape comments continusously from the same post? Sometimes followers may comment a 1-2 days latter.

Thanks Fariha

Was this reply helpful? Yes No
v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @fsheikh,

You could update the "Delay" action on the flow,and set the Delay action to delay two days before run the "Get comments from media" action.

Best regards,

Alice

Was this reply helpful? Yes No
GabrielStJohn Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello, @fsheikh!

Have you had an opportunity to apply @v-yuazh-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify! Thank you for being an active member of the Flow Community!

-Gabriel

Flow Community Manager

Was this reply helpful? Yes No
fsheikh 6 on at

Like (1)

Report
Copy link

Link copied!

I did apply the recommendations, but not all of the comments were addded to the spreadsheet. I ran a giveaway and recieved over 1000 comments and the spreadsheet only shows 151 comments.
Is there a maximum amount of comments that will be loaded to the spreadsheet?

FS

Was this reply helpful? Yes No