cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kmk
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.

 

 

4 REPLIES 4
mdevaney
Super User
Super User

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

Zrouatbi
Frequent Visitor

Hi @kmk ,

 

This is exactly what I am working on right now, have you managed to make this work? if so, how?

 

Thank you in advance.

Zied

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,598)