Answered

Add Row Into A Table Action: (Excel Group) missing Row option (????)

(0) Share

Report

Posted on by CU29071423-0

134

Hi all,
My big goal is to move filtered rows from Dataverse into Excel table. Tried to do this with very nice tutorial https://www.youtube.com/watch?v=-1G5akHxF2w.
and got stuck on very last step, where I don't see Row box. As indicated by Flow Checker.
In all training materials it's there, please help me to understand how I can solve this problem.

Action name and group looks correct, Advanced Option displayed, but no box to enter that Row value.

Do you have it in your Environment ?

Please refer to screenshot below.
Thanks to all and Happy Holidays.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Michael E. Gernaey on at

Like (0)

Report

Hi @CU29071423-0

Please share your file data so we can see the rows and columns

Click on Show Advanced Options

Most Importantly

* If the Column is there, then my GUESS is you did not ADD it to the Table so Table1 is missing it. So please go into the excel file and look at the Table, show a picture etc

Thanks

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Power Platform 1919 1,898 on at

Like (0)

Report

HI @CU29071423-0,
I am guessing few things here, correct me i am wrong.
1. The flow creates a new file excel file
2. and you are trying to add to the newly created file
3. and you're not seeing Row for the newly created file.

if all of my assumptions are correct, then you need to add a Create a table action, after the create file action.
Then do the add a row action

Was this reply helpful? Yes No
CU29071423-0 134 on at

Like (0)

Report

Thanks PA and Michael for feedback,
It's not about content of my file.

Problem solved by itself. In my original post you can see that there is no ROW box and it's already in Advanced view.
That ROW box should be in main view anyway. And this morning I got it like below.

I'm sure 100% it was not there yesterday , my original post proves this. Could be bad day or bug for PA.

Was this reply helpful? Yes No