Forum Discussion
powerautomation
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
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.
2 Replies
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.