Dear,
@Arivalagan, Dinesh Kumar
I tried to understand your problem and solved it after seeing your situation.
I made a space as an example to illustrate your problem with following details.
I made 4 columns for this process to complete in orderly manner. So, I searched a formula on this also as:
=IF(AND([Current Date] > TODAY() + 7, [Status] = "Complete"), "OD", [Status]) which worked and helped me alot!
Title:
current date: having today's default value.
Status: Complete
Attachments
Inputs, Conditions and Triggers are working fine. I performed the manual and Automatic tests to satisfy myself with an example.
Powerautomate worked with Sharepoint. So, now you can try my solution and reach me here.