I am ultimately trying to read content from an excel table (after it has been created which is the trigger), create a SharePoint Item from that row (storing the file locator and row ID in each sharepoint item to retrieve it later) then write back the ID of the created sharepoint item to the excel row.
To do this I used a template of an excel file so I could use the designer to fill in the correct columns to the the sharepoint item fields. Then I changed the file path of the excel file get rows action to dynamically pull from a file when it is created (again the trigger).
The problem I am running into is in trying to use the powerappsid (rowID) from the table in any fashion (i.e. if I write the rowid to the SharePoint item then then the table will not have a powerappsid column created, but if I don't use the rowid field in the sharepoint item the powerappsid column is created).
When I try to write back to the excel row what the SP ID is within a foreach loop (from the get rows action values) I get a 400 value must be provided.)
How I initially Get Rows
For Each Loop Using Output form Get Rows to Create SP Items then Update Initial Rows form the Get Rows Action
Error Received When Trying to Update Row Using the Row ID previously specified
Use of Output from Get Rows in Creation of SP ITem
Trying to Update from Output of Initial Get Rows
