+ Reply to Thread
Results 1 to 3 of 3

Dynamic Array Formula convert to table?

  1. #1
    Registered User
    Join Date
    06-19-2023
    Location
    Toronto
    MS-Off Ver
    Microsoft 365
    Posts
    8

    Dynamic Array Formula convert to table?

    Hi guys:
    I have used a bunch of dynamic array formulas to filter a database into a small filtered section using certain criteria. I really want to use Power Automate to send email notification when one of the array value changes. The problem is for Power Automate to work, I need it to be converted into a table. However, I can't convert the filtered list into a table as any attempt will cause a SPILL error. I am wondering if anybody knows a workaround to this problem? Is this even the right forum subsection to ask? Thank you for your time!

    Kind Regards
    Bill Wu

  2. #2
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,428

    Re: Dynamic Array Formula convert to table?

    Please attach a small sample workbook showing your SPILL error. See yellow banner at the top of this page.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Dynamic Array Formula convert to table?

    As tables do not allow spill ranges, I think you only option is to copy/paste values & then convert to a table.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 03-21-2023, 05:54 AM
  2. convert array data into a table.
    By dwb014 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-24-2023, 02:36 AM
  3. [SOLVED] Need a formula to return an ARRAY prior to dynamic array functions - cannnot do it
    By RamJag in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-02-2022, 08:56 AM
  4. Convert entire range to UPPER - dynamic table VBA
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-10-2016, 10:20 AM
  5. Loop new messages containing a table, populate a dynamic array, paste array to Excel
    By laripa in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2013, 07:20 AM
  6. Convert a dynamic data range into a table
    By Bippa88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2013, 03:08 AM
  7. Dynamic Table Array
    By dawnaptrol in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-30-2010, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1