Forum Discussion
Fill 2 date columns based on an other date column
Hello,
I have a on SharePointsite a document library with 3 date columns: A, B and C
Column C has a certain date and column A must be filled with the date from column C minus 90 days and column B must be filled with the date from column C minus 30 days.
Does anyone know how I can do that?
I know I can use calculated columns in SharePoint but power automate can't read them.
Who knows the solution for me?
Thanks in advance for your reply 😉
Durk Oberman you can do this by creating a new flow which does the date calulations and populates the date/time columns A & B.
So in this example columns A, B and C are all date/time columns. When a new document is uploaded column C will inititally not have any data. The user will then add the date to the file properties:Then your flow will look like this:
Leave the red if no channel empty.
The Document Library custom columns B and A will be updated with the appropriate dates which you can use in another flow.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
4 Replies
Durk Oberman you can do this by creating a new flow which does the date calulations and populates the date/time columns A & B.
So in this example columns A, B and C are all date/time columns. When a new document is uploaded column C will inititally not have any data. The user will then add the date to the file properties:Then your flow will look like this:
Leave the red if no channel empty.
The Document Library custom columns B and A will be updated with the appropriate dates which you can use in another flow.
Rob
Los Gallardos
Microsoft Power Automate Community Super UserYour solution works fine. Thank you for that.
What is see is that the flow constant looks for changes.Will it work when a change the trigger that the flow only runs once a day and what would be then the next action?
- Hi @RobElliot os someone else. Do you have an answer on my previous question: can i change the trigger to for example once a day?
