power automate

  1. M

    Macro or Power Automate to Identify and Move "Washes" from the "Master" Sheet to the "Washes" Sheet

    Hi everyone, I appreciate everyone who takes a moment to read over the problem I'm trying to solve. The image below is a list of 10 records that equal a total of 4 sets of "Washes". Problem: Humans have to manually identify washes and remove from "Master" Sheet. We currently have to highlight...
  2. P

    Updating file that has Bloomberg and other add-in data daily

    I have a 'master' file of 500 tickers/stocks what has around 100 pieces of info for each ticker that has to be pulled and updated through the Bloomberg Add-in and then there's another add in that also pulls some relevant financial info. Because of how much data is being pulled, this often causes...
  3. M

    Power Automate - Save MP3 File from Email Attachment into SharePoint

    Hi All, Not sure if this is the right place to ask this question but it is about Power Automate At the moment - I receive an email which has a recording (attachment) in the format of MP3. I have a power automate flow which detects when i receive an email containing the certain subject line...
  4. brendalpzm

    Send email to several address from sharepoint list according to condition

    I have a sharepoint list where items are input from a form (List1) and another list with users and emails (List2). I want the flow to check whenever an item is created in List1 and look up in the List2 and get all the emails that are classified as Admin in the column Profile and send an email...
  5. xarzu

    What is the proper way to use the '\r' return character in a Power Automate Flow?

    When working with the functionality of reading data from a cvs file into a dataflow, it is required, I believe, to use a schema. It seems to me that this schema has to be designed to accommodate the end of a line in the data. What is the proper way to do this? First of all, It seems that all...
  6. R

    my office script to replace blanks with 0 is not working

    function main(workbook: ExcelScript.Workbook) { let table1 = workbook.getTable("Table1"); // Replace all "" with "0" on table table1 table1.getRange().replaceAll("", "0", {completeMatch: true, matchCase: true}); let selectedSheet = workbook.getActiveWorksheet(); // Set format for range...
  7. xarzu

    Column settings anomaly in not being able to edit.

    Microsoft Lists are part of Microsoft Power Automated Flows. If you want to automate the loading of an excel file or csv file, you are probably going to want your Microsoft Power Automate to load this data in a List. So I think it is important that I figure out how to fix something that I have...
  8. brendalpzm

    Gather Microsoft Bookings in an online excel located in sharepoint with power automate

    I'm creating a booking page with micrsoft bookings and I'd like to gather all the bookings in an excel file like a table or something, I don't know if it might be better in dataverse? I'm not sure. The file that can be exported from microsoft bookings is an tsv file
  9. F

    Power Automate and Arrays

    I have created a form that requires people to upload a file for documentation. I would like to rename and save that form to specific folder on my OneDrive. I am able to save the file to my OneDrive but I am having difficulty renaming the file. In Power Automate, I have successfully parsed the...
  10. M

    Power Automate - Error message for approval

    Hi, Apologies if this isn't the correct area to be asking a question on. Since Power Automate has updated, I can't even complete a simple approval. I have created an MS form that has around 8 questions, these questions get sent to an approver via the "start and wait for an approval" step. These...
  11. S

    Power Automate help - send email with attachment

    Need help creating the following using power automate: Using an existing Excel file stored in Share Point Location: Share Point - The Location Document Library: Document File: The Special File Table: Table 1 Set up a recurrence of daily Sort the table by the 'Date' column Sort the table by...
  12. K

    How to macro will Unhide all the worksheet except the active sheet

    'This macro will hide all the worksheet except the active sheet Sub HideAllExceptActiveSheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Name <> ActiveSheet.Name Then ws.Visible = xlSheetHidden Next ws End Sub This code its working But We need 'This macro will Unhide all...
  13. V

    How to load SAP Analysis Excel file into Microsoft PowerApps

    Does someone have experience with loading data from an SAP Analysis Excel file into PowerApps? I would like to load the data from such a file into Microsoft PowerApps and create an app with it. However I get the following error: I think it's due to the SAP formating of the Excel sheet. I tried...
  14. A

    Power Automate Flow Keeps failing

    i have a power automate flow that basically a form submission happens, it send an email with an approve or reject then it should send an email to the submitter whether they have been approved or rejected BUT when i click approve on the email i get submission has been reassigned
  15. J

    Formula Values Changing.

    Hi All, I have a power Automate flow setup that pulls an excel spreadsheet and then inserts data into the "import" Tab, However, on the other sheets I have formulas that change values. Is there a way to lock these down? This formula in Excel seems to move when data gets added to the import...
  16. P

    [Help] How To? Excel Script: Rename all Sheets - Remove suffix

    Hello, everyone, I hope I'm right here :) I've been working with Power Automate for 2 weeks. Goal: Combine multiple CSV files in one Excel file in different worksheets. Convert CSV files to Excel workbooks - Office Scripts Combine workbooks into a single workbook - Office Scripts...
  17. S

    Using Power Automate To Download and Save from Power BI Dashboard

    I know next to nothing about Power Automate so forgive me if it's very simple. I have to download certain files from a power BI dashboard (like using the export to part) and save them to a certain folder. Is there a way to use the browser version of Power Automate to download files and save them...
  18. W

    Power Automate Creating new rows affecting IF functions that read individual rows. Is there a way to fix this? Offset + If?

    Power Automate is impacting my IF functions by inserting new rows. Each IF function reads a separate row( I.e Tab 1 Cell M7 is read by a IF function on Tab 2 Cell M7). When power automate imports new Microsoft forum data entries, it inserts a row rather than “writing over.” This then throws off...
  19. G

    VBcode to send email to email_list automatically if today's date = date in range

    Want to setup on automatic daily schedule. Ok, to have VBA script in Power Automate Desktop flow but if not necessary that is fine too. Below is the code I am starting with from another post and my example table. Any help would be great! Thanks Full Name First Name Last Name Status Type...
  20. V

    Power Query delete rows containing X?

    Can someone provide me with the line to use in a Power Query to delete all rows that contain a specific value in column 1? I was trying to repurpose the remove blank columns code with list.contains in place of list.isempty but I am not very familiar with the M language...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top