ACE input validation regex property throws error when included in template
I'm trying to use input validation on an input.text field in my card template. According to the documentation an input.text field should be able to accept isRequired, regex and maxLength as validation properties. When you include the regex property in the JSON though, you get the following error: Something went wrong If the problem persists, contact the site administrator and give them the information in Technical Details. ERROR: syntax error at line 1:1 mismatched input ',' expecting {<EOF>, '+', '-', '!', '^', '*', '/', '%', '==', NOT_EQUAL, '&', '&&', '||', '<', '>', '<=', '>=', '(', '.', '[', '??', '?'} I can take the template JSON and put it in adaptivecard.io/designer and it works as expected on a version 1.3 card. If I remove the regex fields from my inputs the other validation types work. Here is the template json. I modified a PNP example card to show the issue. { "$schema": "http://adaptivecards.io/schemas/adaptive-card.json", "type": "AdaptiveCard", "version": "1.3", "body": [{ "type": "TextBlock", "size": "Medium", "weight": "Bolder", "text": " ${formSample.participantInfoForm.title}", "horizontalAlignment": "Center", "wrap": true }, { "type": "Input.Text", "style": "text", "id": "SimpleVal", "label": "Name", "isRequired" : true, "errorMessage": "This name doesnt look valid" }, { "type": "Input.Text", "placeholder": "email address removed for privacy reasons", "errorMessage": "Please enter a valid email address", "label": "Your Email", "id": "email", "isRequired": true, "regex": "^([a-zA-Z0-9_\\-\\.]+)@([a-zA-Z0-9_\\-\\.]+)\\.([a-zA-Z]{2,5})$" } ], "actions": [{ "type": "Action.Submit", "title": "Submit", "data": { "id": "submit" } }, { "type": "Action.ShowCard", "title": "Show Card", "card": { "type": "AdaptiveCard", "body": [{ "type": "TextBlock", "text": "Enter comment", "wrap": true }, { "type": "Input.Text", "style": "text", "id": "CommentVal" } ], "actions": [{ "type": "Action.Submit", "title": "OK" }], "$schema": "http://adaptivecards.io/schemas/adaptive-card.json" } } ] } Has anyone else encountered this issue with ACE and sharepoint online?
Booking System - SharePoint
I created a Booking System using List of Sharepoint, the requirments are as follow Booking Date: This is set to select the desire Date but not today Date or Past Date "I added the Enforce unique values and add the Column validation for it =[Booking Date]>TODAY() with the message to appear as "The date entered cannot be today or in the past." Booking Time: This is set as (Dropdown List) Morning: 07:00am-03:00pm Evening: 04:00pm -11:30pm All day: 07:00am- 11:30pm Now the requirement is If someone wanted to book Lets say on 31-12-2021 can able to book Morning and if someone/Same Person wanted to book on same day evening time can be done but the Uniqe Value of booking date is the issue, it dont allow double booking and if i removed this uniqe value then many ppl can book at same Day and time. And if someone click one All Day even then no one can book Morning and Evening. If anyone knows how please support, Validation or Java Script. Kindly provide the full details im new to this please. Thanks Inadvance.
Uniqueness based within another column choice
Hi, have a unique problem, Column A Number column which needs a unique 4 digit number. Column B Choice column with multiple choices. X, Y, Z There are 4 X, 3 Y and 2 Z. items in the library all the X items need column A values to be unique to other X items all the Y items need to be unique to each other I guess i need a simple validation to check column A uniqueness with other similar column B values. and return invalid if not the case. Am I correct in thinking this is possible, I've not tried validation before and not aware of the code required.