cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AkshayManke
Continued Contributor
Continued Contributor

Cut-off Date and Time of Submission for Different Region

Hi Everyone,

 

I am building an application where multiple forms will be there for all the countries. What i want is: i need to add cut off date and time for each country after that the form should not be submitted.

 

Examples Below:

India: Every 2 day of Each Month at 10:00 AM

UK: Every 4th day of Each Month at 11:30 AM

 

So if the form is for India and current date is 2 & time is 10:30 then the user should be able to submit the form. Similarly for other countries. Can anyone please help on how to achieve this. Many thanks in advance.

 

Kind Regards,

Akshay Manke

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @AkshayManke ,

 

Since there are a lot countries contains multiple time zones, you will need to hardcoded a table to determine which time zone is respective to the selected country. For example, below would be the New York time offsets represents US time zone in the hardcoded table:

CountryName      LanguageCode     TimeZone(UTC offset)     TimeZone(UTC DST offset)

United States           "en-US"                    −05:00                                     −04:00

 

You can use this table in the dropdown for selecting countries and get the respective time zone.

 

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

6 REPLIES 6
KBilakanti1
Microsoft
Microsoft

@AkshayManke ,

You can add condition on SUBMIT Form button click to check the form is for India or US and the time as well, if it's yes then apply your logic else, show error notification.

 

sample syntax:

if(form ="India" And Month(Now()) = 2 And Text(Now(),"hh:mm") = "10:30")
{
................Your true logic..........
}
else
{
................Your false logic..........
}
KBilakanti1
Microsoft
Microsoft

@AkshayManke ,

You can add condition on SUBMIT Form button click to check the form is for India or US and the time as well, if it's yes then apply your logic else, show error notification.

 

sample syntax:

 

if(form ="India" And Month(Now()) = 2 And Text(Now(),"hh:mm") = "10:30")
{
................Your true logic..........
}
else
{
................Your false logic..........
}

 

rampprakash
Power Participant
Power Participant

Hi @AkshayManke ,

 

Please configure cutoff date and time/Countries in Sharepoint List/Data Verse table

While User tries to Submit the form retrieve the Cutoff date and time based on Country

 

Lookup("tablename", Country="India/UK",Cutoff date and time)

then On Submit of Form Validate the Country based @KBilakanti1 Suggestion

AkshayManke
Continued Contributor
Continued Contributor

Hi @rampprakash & @KBilakanti1, Many thanks for suggesting the solution. However my requirement is like the date and time it should pick from the respective region. 

 

For example: if i have selected India in the country field then it should consider IST +5:30  and if I select UK then it should select the respective time zone.

 

Could you please help that how to achieve this?

 

Kind Regards,

Akshay

Hi @AkshayManke ,

 

Since there are a lot countries contains multiple time zones, you will need to hardcoded a table to determine which time zone is respective to the selected country. For example, below would be the New York time offsets represents US time zone in the hardcoded table:

CountryName      LanguageCode     TimeZone(UTC offset)     TimeZone(UTC DST offset)

United States           "en-US"                    −05:00                                     −04:00

 

You can use this table in the dropdown for selecting countries and get the respective time zone.

 

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

AkshayManke
Continued Contributor
Continued Contributor

Hello @v-jefferni,

 

I will try the solution suggested by you and will get back with the results by next week. Many thanks for helping on the same.

 

Kind Regards,

Akshay

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 (1,454)