Share
ReportHello,
I have one excel file. I need to validate excel columns like Name, Date of Birth.How can i validate these columns in power automate cloud flow.
You’re offline. This is a read only version of the page.
Announcements
Hello,
I have one excel file. I need to validate excel columns like Name, Date of Birth.How can i validate these columns in power automate cloud flow.
Hey @Sathya123
You missed an s in contains function in items. You have written item in that.
contains(outputs('Compose'),items('Apply_to_each'))
And also add a 0 to the array of strings. So that if 0 is also there in the name, it will called it invalid. I missed that.
I have an error in Apply to each
Error Details:
Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'item' must not have any parameters.'.
Hey @Sathya123
Save your name in a compose. Make another compose and store array of strings containing each digit.
After this run a apply to each loop with array of digits as the input. After this use condition action and inside use contains function and match it the current item. If its equal to true, there is a digit in the name and if its false there is no digit in the name.
contains function: contains(outputs('Compose'),items('Apply_to_each'))
I hope you like it.
I don't know how your Excel gets filled, but can't you simply do that with Data validation within Excel itself?
https://www.extendoffice.com/documents/excel/3408-excel-only-allow-alphanumeric.html#a3
#1
WarrenBelz
146,508
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,369
Most Valuable Professional
All responses (
Answers (