Extend due date and change status after due date by button

Like (0) Share

Report

Posted on 23 Jun 2023 12:49:05 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 ?

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (4)

Answers (1)

Verified answer

developerAJ 2,855 on 26 Jun 2023 at 14:43:53

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?

Was this reply helpful? Yes No
Karolina776 133 on 26 Jun 2023 at 11:38:05

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

Was this reply helpful? Yes No
Karolina776 133 on 26 Jun 2023 at 11:15:09

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?

Was this reply helpful? Yes No
developerAJ 2,855 on 23 Jun 2023 at 14:30:30

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

Was this reply helpful? Yes No