Unanswered

Filling data into excel report (not table)

(0) Share

Report

Posted on by 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

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
noorfar 52 on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
noorfar 52 on at

Like (0)

Report

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

Was this reply helpful? Yes No