Forum Discussion
Fill 2 date columns based on an other date column
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
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
Your 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?
Durk Oberman yes, you could change the flow to the following:
Rob
Los Gallardos
Microsoft Power Automate Community Super User
