May 18 2022 04:47 AM
I have been searching all over the internet for a solution to this. I am trying to create a column that updates every day with the amount of days from now to a due date.
My current solution is the following JSON code, but this does not allow me to conditionally format. I have tried powerflows, but have been advised against them as have been told they will get to slow as the sharepoint grows.
Could someone provide me with a solution?
May 18 2022 05:11 AM
@eobrie22 you won't be able to do that with just SharePoint as the column with today's date won't update dynamically, it needs the list item to be edited first.
You will need to have a flow in Power Automate with a schedule recurrence trigger set to once a day. Then you will get all the items in the list and finally update the Today column with today's date:
Rob
Los Gallardos
Microsoft Power Automate Community Super User