power automate

I am working on a quote tracking program in excel and would like to streamline the quoting process. I have an office form my sales staff can fill in which populates an excel table for me to see the information. Within the table I have formulas to do many things and one is to compile a lot of the...

Basics of my setup. Working in single workbook with multiple worksheets in a 365 environment tied in to a Power Automate setup on Windows. Workbook will need to be accessible by multiple people and online, hence use of Office Scripts rather than VBA. I'm a relatively advanced Excel user when it...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

'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...

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...

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

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...

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...

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...

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...