Unanswered

Formula Help Needed for Calculating Event Status Based on StartDateAndTime and EndDateAndTime"

(0) Share

Report

Posted on by johnkenshin1234

Hi Power Apps Community,

I'm currently working on a Power Apps solution with SharePoint integration, and I need assistance with creating a formula for calculating the status of an event based on its start and end dates. Here are my specific requirements:

The status should be determined as follows:
- If the current date and time are before the StartDateAndTime, the status is "Upcoming."
- If the current date and time are between StartDateAndTime and EndDateAndTime, the status is "Ongoing."
- If the current date and time are after EndDateAndTime, the status is "Completed."
Additionally, if the event has a CancellationStatus of "Approved," the status should be "Cancelled."

I've tried several formulas, but I'm encountering issues, and the status is not updating as expected.
Second row should be completed but it is not updating.

Here is my Formula on the Status Column

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @johnkenshin1234

try this formula:

If( CancellationStatus = "Approved", "Cancelled", Now() < StartDateAndTime, "Upcoming", Now() >= StartDateAndTime && Now() <= EndDateAndTime, "Ongoing", Now() > EndDateAndTime, "Completed" )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
johnkenshin1234 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Upon Entering the Formula it gave me this error message

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

do you want to directly do it on the sharepoint? If thats the case i guess its not the right forum for it.

Was this reply helpful? Yes No
johnkenshin1234 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry I thougt it was related for this forum since I have this problem on my gallery power apps that is related to the Sharepoint
Thank You!

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

did u set any values directly in powerapps on your gallery or are u doing all the filter things directly in the SP settings?

copy the code u have in SP (just to still have it) an delete it. in the gallery select the text control where u want to show the start-end date and put the above formula in the text property

Was this reply helpful? Yes No
johnkenshin1234 7 on at

Like
a
(0)

Report
Copy link

Link copied!

From I have learned it is filtering the Data On SP
Still learning about Power apps. if you need any properties I can show it to you.
The reply that you sugested and copy pasting the code it did not work
Photo below is the reference I found related on the Status.

@mmbr1606

Was this reply helpful? Yes No