cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Add row to Table has stopped functioning

I have a flow which checks my email for specific emails and adds a row to an Excel table that I use for task tracking.

The flow was working fine for two weeks and has since stopped adding rows, even though it reports successfully adding the row.

 

Flow failure.png

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

I think I have found the issue and it is truly strange.

 

My Excel workbook had a query that was linked to a Sharepoint list (not the one referenced in the FLOW).

Once I broke that connection link, flow was able to add rows to the Table again.

View solution in original post

5 REPLIES 5
MarkStokes
Skilled Sharer
Skilled Sharer

Hrm. This question really needs more detail. We have zero chance of helping you with the information provided.

Please expand out your output actions, let us know what you have tried to resolve this. Was the excel file open in an application or browser when the Flow ran?

There is literally nothing to go on here.

Did you read my post on how to post a good forum post?

If you can give us more details then we can try to help.

- Mark
Anonymous
Not applicable

I cannot expand due to proprietary information (yes even the column names are protected).

I have previously had the flow run properly even while the excel file was open on my desktop (I never use the brower version).

 

I removed and recreated the "Add row" command to insure it was still pointing to the correct file location in SharePoint and the correct table, but with no change in results.

 

The excel table seemed to stop growing at row 50. I am going to create a new Excel file to test this next week and see if the problem continues.

 

It seems very strange that the flow would simply stop midweek without me making any changes to it.

I even checked the SP permisions, but nothing there had changed.

If you are unable to share your column names or data then please build a second “sample” Flow that replicates your issue and share that.

We can’t really help you without more information.

However 50 rows sounds too much like a round number to be a coincidence.

- Mark
Anonymous
Not applicable

I created a new Flow which uses the same trigger, but only has the action to write a new row to a table (Excel Online for Business), but have the same results. The Flow shows as successful, but nothing is added to the Excel Table.

 

I have included an image of the Flow and also copied the resulting Ouput Text below:

{"@odata.context": "https://excelonline-wus.azconn-wus.p.azurewebsites.net/$metadata#drives('######')/Tables('%7B79D1D97...": "", "ItemInternalId": "f0b48ff3-3e4e-457a-83f1-9c199d48c532",
"Course Title": "Test",
"Creator": "Lathbury, John",
"Date Submitted": null,
"Link to File": null,
"Apex Status": null,
"Intradiem": null,
"Date Completed": null,
"Comments": null,
"Deep Link": null,
"Turnaround Time (DD_x003a_HH_x003a_MM)": null,
"Team": null}

Flow failure.png

Anonymous
Not applicable

I think I have found the issue and it is truly strange.

 

My Excel workbook had a query that was linked to a Sharepoint list (not the one referenced in the FLOW).

Once I broke that connection link, flow was able to add rows to the Table again.

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,320)