cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KeithNJ
Level: Powered On

Excel (Business) Add Row - Runs without error but doesn't add row

I have a Flow that adds a row to an Excel file in a SharePoint library.  It runs sucessfully but does not add a row to the table.  This was working and has recently stopped working but I cannot figure out the issue.

 

I even see outputs displayed but there is no data when I open the file,

 

 

6 REPLIES 6
Community Support Team
Community Support Team

Re: Excel (Business) Add Row - Runs without error but doesn't add row

Hi @KeithNJ,

 

Could you share a screenshot of your flow?

According to your description, I have made a flow likes below. When an item is created in a SharePoint list, add a row to a table in a SharePoint library.

It is configured likes below and items could be added in the row successfully.

1.PNG 

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
KeithNJ
Level: Powered On

Re: Excel (Business) Add Row - Runs without error but doesn't add row

The flow sucuesfully completes but when I inspect the file in SharePoint, there has been no modification.  (Not even the date modified)

 

example2.JPG

 

 

Community Support Team
Community Support Team

Re: Excel (Business) Add Row - Runs without error but doesn't add row

Hi @KeithNJ,

 

Thanks for updating.

Could you share a screenshot of the run details of output for action Add a row into a table?

Could you check and make sure each dynamic content you are using in the action Add a row into a table does return a value but not null?

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
KeithNJ
Level: Powered On

Re: Excel (Business) Add Row - Runs without error but doesn't add row

The first is the input and the second is the output
 
{
"Key": "2",
"Topic": "Bahamas Charter - Christmas 2018",
"Contact": " John Fake",
"Owner": "Keith",
"Column1": "USD",
"First Deposit Date": "2018-11-01",
"First Deposit Amount": "200000",
"Second Deposit Date": null,
"Second Deposit Amount": "",
"Fourth Deposit Date": null,
"Third Deposit Date": null,
"Third Deposit Amount": "",
"APA": "20000",
"Charter Drop Off": "Bahamas",
"Charter End Date": "2018-12-30",
"Charter Fee": "250000",
"Charter Manager": " Donald Duck",
"Charter Pick Up": "Bahamas",
"Security Deposit": "0",
"Charter Start Date": "2018-12-23",
"Crew Gratuity": "",
"Currency": " $",
"Delivery Fee": "2000",
"First Deposit Received": "True",
"Referral Source/Agent/Broker": null,
"Tax/VAT": "10000",
"Tax/VAT Percentage": "",
"Third Deposit Amount (Base)": "",
"Third Deposit Received": "False",
"Total to be received": "200000.00",
"Total to be received by N&J": "",
"Wire Details": "8q924987985",
"Wire Details Verified": "True",
"Fourth Deposit Amount": null,
"Referral Source": null,
"Yacht": "11.11"
}
 
{
"@odata.etag": "",
"ItemInternalId": "7d75fc27-6298-45da-b122-399936894796",
"Key": "2",
"Topic": "Bahamas Charter - Christmas 2018",
"Contact": " John Fake",
"Owner": "Keith",
"Column1": "USD",
"First Deposit Date": "2018-11-01",
"First Deposit Amount": "200000",
"Second Deposit Date": null,
"Second Deposit Amount": "",
"Fourth Deposit Date": null,
"Third Deposit Date": null,
"Third Deposit Amount": "",
"APA": "20000",
"Charter Drop Off": "Bahamas",
"Charter End Date": "2018-12-30",
"Charter Fee": "250000",
"Charter Manager": " Donald Duck",
"Charter Pick Up": "Bahamas",
"Security Deposit": "0",
"Charter Start Date": "2018-12-23",
"Crew Gratuity": "",
"Currency": " $",
"Delivery Fee": "2000",
"First Deposit Received": "True",
"Referral Source/Agent/Broker": null,
"Tax/VAT": "10000",
"Tax/VAT Percentage": "",
"Third Deposit Amount (Base)": "",
"Third Deposit Received": "False",
"Total Amount": null,
"Total to be received": "200000.00",
"Total to be received by N&J": "",
"Wire Details": "8q924987985",
"Wire Details Verified": "True",
"Refund": null,
"Fourth Deposit Amount": null,
"Referral Source": null,
"Yacht": "11.11"
}
KeithNJ
Level: Powered On

Re: Excel (Business) Add Row - Runs without error but doesn't add row

Ok I made some changes to make sure there are no null values but I`m still getting the same result
 
{
"Key": "2",
"Topic": "demo charter",
"Contact": " Daffy Duck",
"Owner": "Keith",
"Column1": "USD",
"First Deposit Date": "2018-11-30",
"First Deposit Amount": "100000",
"Second Deposit Date": "2018-11-30",
"Second Deposit Amount": "0",
"Fourth Deposit Date": "2018-11-30",
"Third Deposit Date": "2018-11-30",
"Third Deposit Amount": "0",
"APA": "0",
"Charter Drop Off": "elsewhere",
"Charter End Date": "2018-12-01",
"Charter Fee": "100000",
"Charter Manager": " Daffy Duck",
"Charter Pick Up": "somewhere",
"Security Deposit": "0",
"Charter Start Date": "2018-11-30",
"Crew Gratuity": "0",
"Currency": " $",
"Delivery Fee": "0",
"First Deposit Received": "False",
"Referral Source/Agent/Broker": "na",
"Tax/VAT": "0",
"Tax/VAT Percentage": "0",
"Third Deposit Amount (Base)": "0",
"Third Deposit Received": "False",
"Total Amount": "0",
"Total to be received": "0",
"Total to be received by N&J": "0",
"Wire Details": "test",
"Wire Details Verified": "True",
"Refund": "0",
"Fourth Deposit Amount": "0",
"Referral Source": "na",
"Yacht": "ZOOM ZOOM ZOOM"
}
 
{
"@odata.etag": "",
"ItemInternalId": "46e9b6f5-d5c0-4b9a-84a3-3111cd5abb03",
"Key": "2",
"Topic": "demo charter",
"Contact": " Daffy Duck",
"Owner": "Keith",
"Column1": "USD",
"First Deposit Date": "2018-11-30",
"First Deposit Amount": "100000",
"Second Deposit Date": "2018-11-30",
"Second Deposit Amount": "0",
"Fourth Deposit Date": "2018-11-30",
"Third Deposit Date": "2018-11-30",
"Third Deposit Amount": "0",
"APA": "0",
"Charter Drop Off": "elsewhere",
"Charter End Date": "2018-12-01",
"Charter Fee": "100000",
"Charter Manager": " Daffy Duck",
"Charter Pick Up": "somewhere",
"Security Deposit": "0",
"Charter Start Date": "2018-11-30",
"Crew Gratuity": "0",
"Currency": " $",
"Delivery Fee": "0",
"First Deposit Received": "False",
"Referral Source/Agent/Broker": "na",
"Tax/VAT": "0",
"Tax/VAT Percentage": "0",
"Third Deposit Amount (Base)": "0",
"Third Deposit Received": "False",
"Total Amount": "0",
"Total to be received": "0",
"Total to be received by N&J": "0",
"Wire Details": "test",
"Wire Details Verified": "True",
"Refund": "0",
"Fourth Deposit Amount": "0",
"Referral Source": "na",
"Yacht": "ZOOM ZOOM ZOOM"
}
 
flow4.JPGflow3.JPGflow2.JPGflow1.JPG
KeithNJ
Level: Powered On

Re: Excel (Business) Add Row - Runs without error but doesn't add row

Yes, I have done this.  Also built a new flow from scratch using common data model and get the same results - no excel update?

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,761)