search

microsoft / powerapps-tools

Unsupported PowerApps Tools & Apps
MIT License
1.05k stars 434 forks source link

[BUG]: CoE Nurturing - Unable to start the flow using Excel Online and Sharepoint Connector #965

Closed drace3000 closed 3 years ago

drace3000 commented 3 years ago

Describe the bug CoE Starter Kit Nurturing Setup - unable to get the flow associated with the Sharepoint Document Library working as accessing the spreadsheet assessmentcategories.xlsx generates an error in the associated flow. As a result, unable to start the flow using Excel Online and the SharePoint connector

Screenshots Screen 01 Screen02

JeneferM-MSFT commented 3 years ago

Hello unless you modified the excel spreadsheets then you have made a mistake in selecting either location, document library, file, or table name.

The table name as we shipped it is Table1 image

drace3000 commented 3 years ago

Jenefer, Yes the original was Table1 with the same error. So in testing we renamed to Table12 and again same error

manuelap-msft commented 3 years ago

Hello,

in this action, can you try and reset the values for Location, Document Library, File and Table and pick them from what's available by selecting the drop down arrow. The available files and tables should come up if you click on the drop down. image

Thank you Manuela

JeneferM-MSFT commented 3 years ago

Added note in documentation to ensure people know they have to manually select all the fields in the calls to Excel. Closing out as there is no further action for us here.