You’re offline. This is a read only version of the page.
986
Hi @Paulie78 , @ganeshsanap , @BFS , @DragonLord @Serbay ,
I had a requirement which was as follows:
In Power Apps using attachment control user can upload the file and the contents inside are extracted with the help of Power Automate wherein the uploaded file contents are extracted and then stored in a SP list (which has columns similar to that in Excel file) basically I am importing data from excel and storing in my data-source
(For more information you can check my post: Import from Excel ).
This is the flow:
(Which take the file input from Power Apps attachments control and then maps the details into SharePoint list)
SharePoint list:
Where the data extracted by the flow will be stored
In Power Apps I have provided an download option which users can use to download the Excel template in which they can enter the necessary details and upload the file (to avoid any discrepancies in the structure), the template is:
So now once user uploads the file before the extraction process starts I want to also check if the file which is uploaded is similar to the template if yes continue the normal flow else give an error message saying the file format is mismatch and stop the process.
If you guys have any idea please let me know.
Regards,
Sidhant.
After list "List rows presented in a table", add Parse JSON and add the Shema using previous step output result.
if the file has different Headers, your Parse JSON will fail with mention that the specific header is missing.
after this you can use 'Condition Run after' = If fails on the next step on a parallel branch.
Share
Report
All responses (
Answers (
