web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Validate the Excel col...
Power Automate
Answered

Validate the Excel columns

(0) ShareShare
ReportReport
Posted on by 18

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.

Categories:
I have the same question (0)
  • okeks Profile Picture
    802 Super User 2024 Season 1 on at

    What do you mean with validate?

     

    There is a connector for working with Excel: https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/

     

    It will require you to have your data in a table in Excel.

    The needed actions from the connector depend on your scenario.

  • Sundeep_Malik Profile Picture
    6,499 on at

    Hey @Sathya123 

    Can you provide some conditions on which your validations will be like. The date entered is less than today's date. If the format is correct or not. For name, validation is a little difficult, for name validation can be first name and last name cannot be blank. 

    Below I am giving you some examples: 

    For name: First Name and Last Name are not blank.

    Split Function: split(variables('A'),' ')

    Sundeep_Malik_0-1663064261904.png

    Then on dates you can check that it is less than today's date: 

     

    Sundeep_Malik_1-1663064408398.png

    With conditions you can easily do that validation according to your need. 

    I hope this helps. 

  • Sathya123 Profile Picture
    18 on at

    My requirement is Name only contains alphabet, doesn't contain Numbers and Symbols.

  • okeks Profile Picture
    802 Super User 2024 Season 1 on at

    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

  • Sathya123 Profile Picture
    18 on at

    My requirement is validated columns in power automate cloud flow

  • Sathya123 Profile Picture
    18 on at

    This is my format for Ex: ABCDE1234. I want to validate Name Contains alphabet only.

  • Sundeep_Malik Profile Picture
    6,499 on at

    Hey @Sathya123 

     

    Save your name in a compose. Make another compose and store array of strings containing each digit.

     

    Sundeep_Malik_0-1663149550482.png

    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'))

     

    Sundeep_Malik_1-1663149774459.png

     

    I hope you like it.

     

  • Sathya123 Profile Picture
    18 on at

    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.'.

  • Sundeep_Malik Profile Picture
    6,499 on at

    @Sathya123 

    Can you add the screenshot of the action in edit mode

  • Sathya123 Profile Picture
    18 on at

    Sathya123_2-1663170905985.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 281 Super User 2026 Season 1

Last 30 days Overall leaderboard