You’re offline. This is a read only version of the page.
Good morning everyone,
I'm working on a form to email the submitter if they complete the form with an incorrectly formatted time (which would not be an issue if Microsoft gave us a dedicated time field- arg). I've got the flow set up with the trigger of the form being filled out, followed by get responses.
The issue is that everyone who fills out the form, even with correctly formatted times, is getting the message. The condition must have an error somewhere, but I can't figure out what it is. I'm sure it's something simple, but I can't figure it out.
Any thoughts?
Thanks,
-Matt
I figured out a workaround - I'm using the presence of a space or not to trigger the error. If there is no space, it triggers, if there is a space it does not.
It would be better if it could actually check it as a proper time in case someone makes another error, but this should work for now.
@Matthy79 - I think that is most of the issue. The problem I'm trying to catch is when people do not put a space between the time and the am/pm, for example 10:00AM instead of 10:00 AM. While you can't see it in the screenshot, I've got a space before the AM/PM, with the intent of it triggering if it did not have a " AM" or " PM." Unfortunately, it looks like it is just registering that an AM/PM is there. I tried adding quotation marks to get an exact match, but they did not save in the script.
There are more errors.
for example. Every time that Endswith AM won’t end with PM so the condition will always be true.
if you want to check it that way you will have to group some of the condition. But I think you should check if it is a valid date.
I‘m not so good in Forma but I‘m sure there is a better way to handle times.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (
