cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

How to apply validation to selected excel file from powerapps.

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 rows

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

 

your idea would greatly appreciated.

 

 

3 REPLIES 3
Highlighted
Super User
Super User

Re: How to apply validation to selected excel file from powerapps.

@kmk 

If this is possible it would have to be done in Microsoft Flow.  I'll provide a link to that community.

Link to Power Automate Community
https://powerusers.microsoft.com/t5/Get-Help-with-Power-Automate/ct-p/FL_GeneralDiscussions

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Highlighted
Helper V
Helper V

Re: How to apply validation to selected excel file from powerapps.

Hi @mdevaney 

 

Then how to take it(selected input file) as input parameter in to MS flows from powerapps

Highlighted
Super User
Super User

Re: How to apply validation to selected excel file from powerapps.

@kmk 
I don't know the answer to your latest question.

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (7,345)