Unanswered

Action 'Add_a_row_into_a_table' failed - Power apps for teams power automate workflow

(0) Share

Report

Posted on by GU-11121327-0

Hello,

I am unable to run this power automate flow as it fails all the time . So basically this is a power apps for teams and I trying to execute export of data from a database table to excel on sharepoint site folder creates for the same teams app

I am not getting any clue why this is failing as it does not provide enough information on whats causing it to fail. Anyone coming across similar issues?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

rzaneti 4,241 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

I'm assuming that you are using a few dynamic contents to populate your Add a row into a table action, since your goal is to load data to a newly created file. For debugging purposes, could you please create a manual copy of the Excel file and populate the Add a row into a table inputs with the details of this manually created copy?

If your flow works after it, we will be able to isolate the error cause, and then you must to double check the entered dynamic content used in the action and test the flow again.

If the error persists, please share an image of the inputs used in your Excel action (make sure to remove any sensitive data before sharing it).

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Accepted Answer.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No
GU-11121327-0 6 on at

Like (0)

Report

I managed to solve this

@rzaneti Thank you so much for your reply. I made the necessary changes as per your suggestions and this is actually working . Just to summarise for everyone benefit

I was trying to create a new file each time for the export so instead of that I created the file manually on sharepoint and used that file as a reference and that resolved my issue

@rzaneti Data is getting exported now however my other issue is some of the lookup columns the real data is not exported . It seems since the tutor column is a lookup field to the master data it seems to export the reference although my table which save the data has actual tutor data collected from the master file so not sure why it exports this reference data

i Have listed a example below. Are you able to help with this one as well ?

Was this reply helpful? Yes No
rzaneti 4,241 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

I'm glad that it worked for you! About your "Tutor" issue, it looks like you are using the dynamic content of the Tutor lookup column in Dataverse as an input to your column in Excel. As a result, you must get the Tutor's ID, and not the Tutor's name (which is displayed in DV).

There is an easy workaround for it. Inside your Apply to each, add a Get a row by ID action, since it returns some additional fields. Make one flow run with the Get a row by ID action inside your loop and check their raw outputs and search for the "Tutor" field. In the example below, I'm doing the same process with the Accounts table to access the details from "Primary Contact" column:

Highlighted in green is the lookup field id, which is the what you are returning right now in your flow. Highlighted in red, we have the respective contact name (in your case you will see the Tutor name), which is the desired output.

At this point, you can copy the property name related to the Tutor name and use it in an expression to load it to your Excel file. For my case, I would need to use the expression outputs('Get_a_row_by_ID')?['body']['_primarycontactid_value@OData.Community.Display.V1.FormattedValue'], where the text in red is the property copied from the raw outputs.

I will run the flow again with this Compose action just to illustrate the difference of the outputs:

And those are the final outputs:

As you can see, the expression returns the lookup label rather than its id.

For further instructions related to this process, I recommend you to check this blog that I wrote in the past about the topic: http://digitalmill.net/2023/09/18/returning-lookup-and-choice-columns-from-dataverse-in-power-automate/

If you don't know how to access the raw outputs in Power Automate, refer to this article: http://digitalmill.net/2023/06/29/how-to-access-the-raw-outputs-in-power-automate/

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Accepted Answer.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No