Forum Discussion
David_Bravo
Aug 09, 2021Copper Contributor
Actualizar lista vinculada desde una bbdd
Hola, Estoy haciendo un proyecto que consiste en tener un formulario en sharepoint (powerapps), con una lista en sharepoint y queria insertar datos masivamente desde un excel que tengo en local con ...
Aug 09, 2021
Hi!
Do you need the Excel file to be stored locally? If you were able to store the file in a SharePoint Site, I think you should have more alternatives to process it
Do you need the Excel file to be stored locally? If you were able to store the file in a SharePoint Site, I think you should have more alternatives to process it
David_Bravo
Aug 09, 2021Copper Contributor
Hi, I would give the same if the file was in sharepoint online. but if the file is in sharepoint online it should be opened first to modify any value and then open it again to update the connection and data.
Specifically, what I need is to read data from an excel with iqy connection for it:
- open excel
- modify data in some additional tab so that the connections are updated
- save the contents in table format so that you can read it power automate.
the current problem I have is that power automate the connection file does not read it as a table even though it has a table.
Greetings
David