Sky API Gift List into Sharepoint

David Orndorf

Hi Everyone,

I am trying to create a scheduled flow to import a gift list weekly as an excel file in SharePoint. I keep getting an error stating that there is no valid input in the “Add a row into a table” action.

Alex Wong

@David Orndorf
Your screenshot isn't showing.

Will need you to show the edit mode of the flow for the action that “add a row to table”, as well as a run history of that action and the previous actions (i.e. create excel file and create table).

Depending on how many gifts your org process in a week, doing the method you trying to do may take too long as processing 1 gift at a time for more than a few dozens gift can take a while. Consider:

1. using fast saving in bulk
   https://community.blackbaud.com/forums/viewtopic/426/65782
2. use Query API to get a csv directly
   if you can't/don't want to work with csv and need to be excel, you can check this post out to turn csv to excel table
   https://community.blackbaud.com/forums/viewtopic/586/63726

David Orndorf

@Alex Wong Hi Alex, I am trying the fast save template but I keep getting this error message during import.

Alex Wong

@David Orndorf

Configuration details:

• Download Column Number to Letter.xlsx and save it in SharePoint somewhere
• OPTIONAL: Download CommonFormat.zip extract the CommonFormat.osts file and save it to your OneDrive > Documents > Office Scripts folder
  • There is an action at the last step of the process to do a nice common format (autofit columns, autofit rows, freeze header row, make the data range a table and give it a table name of “GiftTable” (which you can change in editing the script, not in scope for this post)

the OPTIONAL i guess is not optional with the flow saved the way it is. you are missing the script that does the common format of the excel table.

David Orndorf

@Alex Wong
Okay, I will try that and see how to processes through. Thank you!