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 Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (1,838)