Flow for column calculation in Excel (Company), push notification.

[maxiq_2k]

Good afternoon, first of all thank you very much for reading this post, I have a problem, I am starting with the workflows and a question arose, I am making an app in Powerapps, in which one date appears in one of its columns, I want With a programmed flow, applying to each one, I need the date of the column to be subtracted from today's date plus 15 days, and I cannot hit the key, the one that has achieved this, would be very helpful, then I need a notification sent to the cell phone, by powerapps.

[DeepakS]

Hi @maxiq_2k 

It seems more Power Apps question, you can add columns to your data source for computed date something like this:

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

[maxiq_2k]

I think it does not explain to me well, what I want is for the flow every day to perform a calculation on the Excel file, the calculation that will be made on the DATE column, I want you to notify me 15 days before, with a notification to the cell phone , without me having to do anything, only the flow is done automatically.

[DeepakS]

Hi @maxiq_2k 

I think I misunderstood you. if you want to use Power Automate here are the steps:
1) Create a Schedule Power automate that will run every day
2) Connect to your excel and get all rows using action -List rows present in a table
3) use the following condition to check if the date from excel is equal to today-15 days,
you can use the following expression in the condition action
addDays('12-30-1899',int(items('Apply_to_each_5')['Date']),'yyyy-MM-dd') is equal addDays(convertFromUtc(utcNow(),'Central Standard Time','yyyy-MM-dd'),-15,'yyyy-MM-dd')

Change items('Apply_to_each_5')['Date'] with your excel date column.
Change 'Central Standard Time' to your time zone
4) if the condition is true you can add other steps that you want to perform

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

[maxiq_2k]

Soy muy novato en esto,te paso capturas de como me quedan los pasos para llegar a resultado, no se si esta bien. Adjunto fotos

Saludos.

[DeepakS]

Hola @maxiq_2k 

Aquí hay un ejemplo, espero que esta ayuda:

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.