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
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
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
@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?
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
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2