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 Apps / How to apply validatio...
Power Apps
Unanswered

How to apply validation to selected excel file from powerapps

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi Mates,

What is your idea on below requirement.

1. Screen1: When users click on button, a window(Screen2: or form) should open for select excel file, means like browse and select file.

2. Once selected excel file, return to Screen1, here another button for validate the selected excel file data(loop all the rows and check if correct format or not).

 

here challenge is how to validate selected excel file rows

where can we validate example: query in sql table or MS flow etc..?

 

your idea would greatly appreciated.

I have the same question (0)
  • Rick Wilson Profile Picture
    160 on at

    My initial though would be to use flow.  Here is a great article from Stephen Siciliano on how to get your file to Flow from a Canvas app, upload the file on OneDrive, and return the data back to the canvas app as a Table.

    https://flow.microsoft.com/en-us/blog/howto-upload-return-file/

     

    You could also just have the flow do all the processing of the excel data and have it return a response as to it's success.

     

    More on Respond To PowerApps Action.

    https://docs.microsoft.com/en-us/business-applications-release-notes/april18/microsoft-flow/return-data-powerapps

     

    --Rick

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @RAWilson 

    Thanks for reply..

    in my case we have to read from excel and write in to sql table 

    can you help us.

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 Apps

#1
Vish WR Profile Picture

Vish WR 633

#2
11manish Profile Picture

11manish 588

#3
Valantis Profile Picture

Valantis 457

Last 30 days Overall leaderboard