Extend due date and change status after due date by button

(0) Share

Report

Posted on by Karolina776

133

Hello,

I am creating an app in which i Have a form with "due date " data card which is 30 days later than todays date. I want to create a button on another screen who let me extend this "due date" by next 30 days by click on it. I create funcion in this button:

DateAdd(ThisItem.'Duedate',30,TimeUnit.Days);

But it does not work.

How can I do this ?

Moreover I want to change the status column if the date is After "due date" to "outdated". Can yo help ?

All responses (4)

Answers (1)

Verified answer

developerAJ 2,855 on at

Like (1)

Report

Re: Extend due date and change status after due date by button

"Network error when using Patch funcion: Conflicts exist with changes on the server, please reload"

This error usually comes up if there is mismatch in sharepoint and powerapp item.
for example you have a item title:TitleA
when you loaded the app you have TitleA
someone updated the item: TitleB
and you tried updating the item:TitleC (its trying to convert TitleA to TitleC but it should convert from TitleB to TitleC)

Ok, I found the problem is that column "Due date" is depend on another column : "Start date" the formula is:
due date = start day +30 are you not storing the Duedate in sharepoint?
Karolina776 133 on at

Like (0)

Report

Re: Extend due date and change status after due date by button

Ok, I found the problem is that column "Due date" is depend on another column : "Start date" the formula is:
due date = start day +30
Karolina776 133 on at

Like (0)

Report

Re: Extend due date and change status after due date by button

I use your funcion and I have an issue:

"Network error when using Patch funcion: Conflicts exist with changes on the server, please reload". What I did wrong?
developerAJ 2,855 on at

Like (1)

Report

Re: Extend due date and change status after due date by button

Status is choice
Patch(ursharepointlist,ThisItem,{Duedate:DateAdd(ThisItem.'Duedate',30,TimeUnit.Days),Status:{Value:"outdated"}})

Status is Text column
Patch(ursharepointlist,ThisItem,{Duedate:DateAdd(ThisItem.'Duedate',30,TimeUnit.Days),Status:"outdated"})

I Assume due date is datecolumn

Please click Accept as solution and Thumbs Up. if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
You can connect with me on LinkedIn