power automate

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

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

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

Hi Guys, I have a USERFORM managed database, and I want to add a new feature to create MS Planner tasks from the Excel. I couldn't do that, but now I can do it from Power Automate --> Flow. The only thing I would need to automate to run the Flow from the VBA. Do you have any idea, how to do it...