Automate a Sharepoint column to add date

[johnm_]

Hi,

I am new to power automate so pardon my ignorance 🙂 I was wondering if someone can help me come up with a flow on my sharepoint list.

I want to create a flow to add a date automatically to a column when the day ends. Todays date and time 23:59

Below is what my list look like 

Normally the Checkout Datetime column is empty until someone clicks a checkout button on a powerapp I built. The issue is when someone forgets to click the button for the day I have to click it myself the following day.

I want to create a flow that adds a date by itself when the day ends.

Thanks in advance for the help 🙂

[cchannon]

First, the trigger:

- You want to set up your trigger to run the flow on a Schedule. Specifically, you want to run it every day, starting at 23:59.

Next, the action:

- You'll want to use the SharePoint Connector, Get Items action to search for all values in your list where this column is blank, then set the value in the column to Now().

[johnm_]

@cchannon Hi thanks for your help

searching for the right trigger, will keep you posted.

[cchannon]

First, when you click new flow, pick Scheduled:

Then give it a schedule like this:

[johnm_]

@cchannon 

Hi so I've created the trigger to run at 23:59 everyday (see below)

I also connected my sharepoint list with the Get items action (see below)

But I can't seem to find where to add values in my list where the specific column is blank, then how to set the value in the column to Now().

Thanks again and pardon my ignorance to this 🙂 

[johnm_]

@cchannon I don't see any option to Get item to search empty fields column.

Can you please advice? Thanks!

[cchannon]

What you're looking for is the null operator (when evaluating the condition, just search for rows were your column =null) 

This older post might help: https://powerusers.microsoft.com/t5/Building-Flows/Get-Items-Filter-Query-to-select-null-dates/td-p/...