Google Drive Trigger Workaround

[Beulmoto]

I'm looking for a workaround to create a google drive trigger.

I had the following idea, but not sure if it's feasible.

1. Starting with a recurrence every 15 minutes
2. Get file metadata using path from google drive
3. Add conditional step using an expression saying if last modified time is less than 15 minutes ago to perform an action, otherwise terminate the flow (And this is the part that I'm having trouble with)

I think that something could be done using a formula with a date an time function that outputs a boolean value, but I haven't come up with anything that works yet.

I presume that google drive triggers will eventually be offered, and saw a few request in uservoice that I voted for.

I'm wondering if anyone has landed on something similar.

[v-bacao-msft · Accepted solution]

Hi @Beulmoto ,

You could organize the ideas and specific scenarios you need for Google Drive and submit them to the Idea forum, which is easier to follow and adopt.

We would also recommend more users to vote on this idea.

Also, regarding your idea, it seems that we can rely on the current feature to configure a similar Flow.

I have created a similar Flow according to your description here, you could use it as a reference.

Expression reference:

formatDateTime(body('Get_file_metadata_using_path')?['LastModified'],'yyyy-MM-ddTHH:mm:ssZ')

addMinutes(utcNow(),-15)

Image reference:

Please take a try.

Best Regards,