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:
Createitem_Title: user email
Createfile_FileName: Name of the excel file
Createfile_FileContent: Content of the excel file
4. The I have a Flow that receives these parameters and their information:
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:
6. After creating the item, I create the file with the parameters of the above step:
7. Then I update the created item with the following:
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:
9. Now where I get the issue is here:
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:
Yes the screenshot was missing, the forum said I had inserted invalid html.
Below the screenshot:
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:
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.
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 :
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
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Many congratulations to the Season 1 2021 Flownaut Crew!
Check out our new profile badges recognizing authored solutions!
Check out the community blog page where you can find valuable learning material from community and product team members!