cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Super User III
Super User III

@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."

Hi @mdevaney 

 

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

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

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (8,631)