Flow to Move Scanned Images in Microsoft Lists to Onedrive

[kdillon]

We use Microsoft Lists to keep track of incoming checks. We have Check #, Issue Date, Etc - then the final column is a scan of the check itself. I'd like to build a flow that automatically takes all the scanned checks of a specific date, or date range from Lists and automatically moves them to a folder in OneDrive. Is this possible?

[v-yiwenxie-msft · Accepted solution]

Hi @kdillon 

Yes. This is possible.

In my understanding, you want to move images in sharepoint column to OneDrive. And those images are in a specific date range.

You can add those images in ‘attachments’:

That will be much easier to create image file in OneDrive. Because it didn’t work when I used an image column to create image file in OneDrive.

The whole flow is as below:

The ‘condition’ used here is to check if these images are in a specific date range.

The two rows of condition are:

The value of the column ‘issue date’ is greater than or equal to seven days before today(the day when the flow runs).

The value of the column ‘issue date’ is less than or equal to today(the day when the flow runs).

The functions used:

addDays(formatDateTime(convertFromUtc(utcNow(),'China Standard Time'),'yyyy-MM-dd'),-7)

formatDateTime(convertFromUtc(utcNow(),'China Standard Time'),'yyyy-MM-dd')

The detailed steps of ‘If yes’ in ‘Condition’:

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.