cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DHAGZ
Helper III
Helper III

30DAYS

Good Day!

asking for help.

how to make 30 days lapse in SharePoint ?

My code in POWERAPPS.
DUE DATE: DateAdd(StartDate.SelectedDate,30)

I have Date picker called(StartDate) and Label called (Due Date)
in label display the 30 days from the StartDate


ex.: StartDate : 5/4/2021 and the DUE DATE: 6/3/2021 then save this in my data source

what I want in my SharePoint calculated values to identify if the due date is/are lapse
then Automatic display the "30 Days have been reached"

 

 

any suggestion?

thanks and advance. 





1 ACCEPTED SOLUTION

Accepted Solutions
v-jefferni
Community Support
Community Support

Hi @DHAGZ ,

 

I'm not sure that I have get the point. Would you like to make SP list calculated column display different strings base on the comparation between the DUE_DATE value and today?

 

If my assumption is correct, it seems to be a SharePoint question.

 

Anyway, I made a test that I created a calculated column with the formula below:

=IF([DUE_DATE] >= Today(), "30 Days have been reached", "")

v-jefferni_0-1622446848243.png

 

It looks like could achieve your need. Please have a try.

 

Hope this helps.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

4 REPLIES 4
v-jefferni
Community Support
Community Support

Hi @DHAGZ ,

 

Could you please explain a bit more of your scenario? Do you mean to display the sentence when the due date in the Label is later than the lapse date? Then how do you define the lapse date in SharePoint?

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

DHAGZ
Helper III
Helper III

@v-jefferni Thanks for your reply.

please see attached

Untitled.png

v-jefferni
Community Support
Community Support

Hi @DHAGZ ,

 

I'm not sure that I have get the point. Would you like to make SP list calculated column display different strings base on the comparation between the DUE_DATE value and today?

 

If my assumption is correct, it seems to be a SharePoint question.

 

Anyway, I made a test that I created a calculated column with the formula below:

=IF([DUE_DATE] >= Today(), "30 Days have been reached", "")

v-jefferni_0-1622446848243.png

 

It looks like could achieve your need. Please have a try.

 

Hope this helps.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

v-jefferni
Community Support
Community Support

Hi @DHAGZ ,

 

Have you resolved the issue? 

If above post helps, then please consider Accept it as the solution to help the other members find it.


Best regards,
Community Support Team _ Jeffer Ni

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,158)