Answered

Automatic update in a sharepoint list

(0) Share

Report

Posted on by YD-01101438-0

In Microsoft list. How to ensure that each day the current date is automatically entered in the empty boxes of a column in date format

Categories:

Connector development

All responses (5)

Answers (1)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hey

i dont really understand what you are trying to do. Can you please explain more details.
YD-01101438-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

HI

I created a list in Microsoft list. I have a date formatted column whose default value is =NOW(). When I add a new line to the list, the current date is automatically entered. However, the date is not updated every day. I would like the current date to be automatically updated once a day
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

so you want that all rows have the same date of todays date and all rows in that list should be updated every day to todays date?
YD-01101438-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Exactly
Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

then power apps is not the right tool for that.

you would need to use power automate for it and create new workflow

1.) put a recurrence trigger so the flow runs every day

2.) Get items action and select the sharepoint site and list

3.) Add an appy to each loop and use the value dynamic content of the Get items action

4.) Inside that apply to each loop put Update item action in and choose the Title and ID of the Get items action

You would need to match all the dynamic contents in the columns except of the date column you want to modify the date.

there u put utcNow() in the expression.

if that helped please let me know and mark as verifies answer

cheers