cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

List rows present in table - Not supported file format

Hello guys I hope you are doing great! I'm struggling with an issue in powerapps, using the connector of "List rows present in table".

 

The process is as following:

1. First I add an Excel file into the power apps.

2. Then when click the send button it send the following parameters to the flow:

 

gabrielsoto_0-1610465083634.png

3. 

Createitem_Title: user email

Createfile_FileName: Name of the excel file

Createfile_FileContent: Content of the excel file

gabrielsoto_1-1610465165516.png

 

4. The I have a Flow that receives these parameters and their information:

gabrielsoto_2-1610465356135.png

 

5. Then I have the following action of Create Item in SharePoint List. The objective of the flow is to extract the Excel data and get it into a SharePoint list, and have a register of the files being created:

gabrielsoto_3-1610465531552.png

6. After creating the item, I create the file with the parameters of the above step:

gabrielsoto_4-1610465622418.png

7. Then I update the created item with the following:

gabrielsoto_5-1610465717774.png

8. After that I use a Get File properties Action step. Where I get the Identifier of the file to be used in the excel action step:

 
Get File properties Body:
 
"{Identifier}": "Shared%2bDocuments%252fGeneral%252fAutomation%252fArchivos%252f128%2b-%2bArchivo%2bJacqueline.xlsx",
"{Name}": "128 - Archivo Jacqueline",
  "{FilenameWithExtension}": "128 - Archivo Jacqueline.xlsx",
  "{Path}": "Shared Documents/General/Automation/Archivos/",
  "{FullPath}": "Shared Documents/General/Automation/Archivos/128 - Archivo Jacqueline.xlsx",
  

gabrielsoto_6-1610465811078.png

9. Now where I get the issue is here:

 
 

asdf.png

 

 

 

 

 

File: Shared%2bDocuments%252fGeneral%252fAutomation%252fArchivos%252f128%2b-%2bArchivo%2bJacqueline.xlsx

 

 

 

 

 

 

There you can see that the identifier has a correct format for excel file format.

Im using the identifier from the get file properties step. The issue is the following:

 

 

4 REPLIES 4
Solution Sage
Solution Sage

The issue is the following: ????

missing any screenshot  ??

Yes the screenshot was missing, the forum said I had inserted invalid html.

Below the screenshot:

gabrielsoto_0-1610541805864.png

It says that the file has wrong format. But if you can see, the identifier for the file has the correct xlsx format. When I try to open the file in the explorer from my pc, the file has the following pop up:

gabrielsoto_1-1610541902035.png

 

My hypothesis is that maybe the file is getting corrupted when uploading it through power apps (?) Not sure, The fileContent is correct when extracting from the PowerApps.

 

Solution Sage
Solution Sage

Yes, thats correct the powerapps is not uploading the file correctly. Check this video from Shane Young.

 

The file itself is corrupted, hence you are getting the error and I have faced this in past.

 

Follow steps shown in this video and the issue will be resolved :

 

https://www.youtube.com/watch?v=3QaiM8SeWfM

 

Hope this helps.

Thanks for the Video and quick response @jinivthakkar . Nonetheless, the process I'm using to upload the file is the same as his, I already used his video. This process was working before, now that I'm trying to replicate the flow, I'm having that issue :s

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (74,783)