How to apply validation to selected excel file from powerapps.

[kmk]

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.

[mdevaney]

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

[kmk]

Hi @mdevaney 

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

[mdevaney]

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

[Zrouatbi]

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