Filling data into excel report (not table)

[noorfar]

Hello, I have a form on an excel sheet I want to use power bi connector to fill the data directly into the form.. is that possible? cause farther that I know the data will be filled on the tabular form?

to demonstrate: the table on the right is the form that I want to fill, currently power bi fills the data in the table on the left

[DamoBird365]

Hi @noorfar 

If you are looking to use native actions, there needs to be a table.  If you have access to Office Scripts, you can write data to Excel in any cell you choose by building a bespoke script.

Check out https://www.youtube.com/watch?v=L67m8wgd4Ak&t=761s or https://www.youtube.com/watch?v=Q7GLQnvJJF0

Here are the official docs Office Scripts samples - Office Scripts | Microsoft Docs

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts. Thanks

[noorfar]

@DamoBird365 thank you very much for sharing this. this is exactly what I need! what do I need to create the excel script for my monthly report form?

[DamoBird365 · Accepted solution]

Hi @noorfar 

If you watch my 2nd video, you will get the basics.  Jump to this point Excel Office Script Tutorial - Populate an Excel File Dynamically from Power Automate - YouTube if you want to see how to populate specific cells in a sheet from Power Automate.

Damien

[noorfar]

Hello @DamoBird365 .. I'm facing this error:

error: The 'inputs.parameters' of workflow operation 'Run_script' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'ScriptParameters/grand_total' is required to be of type 'Number'. The source type/format 'Array' of the value '[{"grand_total":"\"293\""}]' is not convertible to type/format 'Number'.

this is my flow:

 these are the details:

 

 

 

I'm trying to run this script just to test the flow:

excel script is :
//Main sheet
function main(workbook: ExcelScript.Workbook,
grand_total: number
) {
let selectedSheet = workbook.getActiveWorksheet();
// Set range D6 on selectedSheet
selectedSheet.getRange("D6").setValue(grand_total);

the whole thing is to fill a set of cells arranged the same as the image in the first question at the beginign of the thread