Skip to main content
Community site session details

Community site session details

Session Id : Fu6/G8B9W3cGwjAmmGZWKR
Power Automate - Using Connectors
Answered

Filling data into excel report (not table)

Like (0) ShareShare
ReportReport
Posted on 5 Sep 2022 14:31:15 by 52

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

noorfar_0-1662388000208.png

 

  • noorfar Profile Picture
    52 on 16 Sep 2022 at 17:29:52
    Re: Filling data into excel report (not table)

    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:

    1.jpg

    these are the details:

    2.jpg

    3.jpg

    4.jpg

     

    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

  • Verified answer
    DamoBird365 Profile Picture
    8,942 Microsoft Employee on 06 Sep 2022 at 11:20:20
    Re: Filling data into excel report (not table)

    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 Profile Picture
    52 on 06 Sep 2022 at 10:14:12
    Re: Filling data into excel report (not table)

    @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 Profile Picture
    8,942 Microsoft Employee on 05 Sep 2022 at 15:11:32
    Re: Filling data into excel report (not table)

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Featured topics

Loading complete