powerautomation

[Anonymous]

Hi, I would like to export from powerbi to an excel workbook with a table already set up 
I use the template "Update an Excel file from PowerBI"
After the "On Power BI button Clicked", the next step is undate a row.  I fill it out but there is no key calue or key column in my download or the file I'm exporting to.

So I used the creation date since it was unique.
I try to populate they key Column / key value fields, but i have no unique id. so I use creation date as the field in the key column.

Now I can't get to any of the fields in the source or destination files.  So....I can't populate the fields, I can't seem to get past this step.  What am I doing wrong?

From the screen image. 
I don't ave  a key value so I'm forcing in a creation date which is unique on each record
The fields marked with [Blocked] are from the table.  But as you can see, no fields are available.

Any help is appreciated.
Thanks
 

[Anonymous · Accepted solution]

Hi @Anonymous ,

Based on my research, it's belong to Power Automate Fundamentals.

Please refer to

Power Automate Fundamentals # 39: Update A row in Power Automate

Values should be provided as follows:

Location : OneDrive for Business
Document Library : OneDrive
File :ExcelWorkBooks/Employee.xlsx
Table : Table1
Key Column: Sno [This is the column which is present in Table1 in Spread sheet]
Key Value : Sno [Select Dynamic value present in List rows present in a table]
Date : triggerOutputs()['headers']['x-ms-user-timestamp']

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Based on my research, it's belong to Power Automate Fundamentals.

Please refer to

Power Automate Fundamentals # 39: Update A row in Power Automate

Values should be provided as follows:

Location : OneDrive for Business
Document Library : OneDrive
File :ExcelWorkBooks/Employee.xlsx
Table : Table1
Key Column: Sno [This is the column which is present in Table1 in Spread sheet]
Key Value : Sno [Select Dynamic value present in List rows present in a table]
Date : triggerOutputs()['headers']['x-ms-user-timestamp']

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Thanks for your help!