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 ?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

developerAJ 4,763 on at

Like (1)

Report
Copy link

Link copied!

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
Karolina776 133 on at

Like (0)

Report
Copy link

Link copied!

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
Karolina776 133 on at

Like (0)

Report
Copy link

Link copied!

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
Verified answer

developerAJ 4,763 on at

Like (1)

Report
Copy link

Link copied!

"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