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:
3.
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:
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",
9. Now where I get the issue is here:
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:
