flow

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

Hi, I am trying to solve Coupled PDE describing flow of two fluids in centrifugal field. PDEs are solved using Newton iteration method using fully implicit scheme for pressure and saturations. In short, I established a matrix of partial derivatives (Jacobian), which are used to find incremets...

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

Hello, thank you so much for the help that's so kindly given here always! :) I want/need to do something so simple, it's got to be possible. Whether I have text wrap selected in Format Cells or not, it seems impossible to allow two lines of text I've created (using an alt+Return) to flow...

Hello World, My work is upgrading Office 365 and I've seen a demonstration of MS Flow which looks like the personal automation revolution that Excel VBA was 20+ years ago. I've learnt so much from this forum but now I am wondering if there is a forum for Flow. I wait with baited breath, Thanks,

Hi folks! I just created an account, because i need some help. I have lots of excel sheets. All are linked together. It is just a mess. So i am trying to visualize the flow of data through all sheets. I already made a table with all sheets and all dependencies. It looks like as follow...

2 workbooks. One called "Cash Flow"; the other called "Budget" In the workbook Cash Flow, there are different months on each worksheet (January, Feb etc). Within Budget, there are columns titled Jan, Feb, etc. I want to pull a specific cell or range of cells within January (Cash Flow) and...

I have a spreadsheet that I want to pull data from 5 different columns using SUM(VLOOKUP as an array. Problem some of the cells may be blank which leads to an #N/A error. I attempted this: {=IFNA(SUM(VLOOKUP(AB8,'Cash Flow Detail '!B12:AN94,"<>",{24,26,31,33,39})),0)} however that returns a...

Hello, I am performing a hydraulic study on a water treatment plant and I have run into something I don't know how to do. This plant has four clarifiers (two different sizes) fed by a splitter box that does not distribute the flow evenly. I need to take the calculated flow and put that into a...

Hi Everyone, I am using power query to access a file from share point. I used Microsoft flow to connect an email folder to outlook (get attachment). This folder will receive an attachment everyday. So far only two days this flow has worked. Here is the error that I am getting. "External table...

Good Day!! I am a long time user of the Mr. Excel Forums. THEY ARE GREAT!!! I am looking for recommendations for a similar forum for Microsoft Flow. Thank you in advance!

I have a 4 step flow chart to follow to put the correct item in the cell dependent on what' in previous cells. Is it possible for me to use a, long, IF statement? The flow chart will never change so I'd only need to do it once! The flow chart is Is it A or B If A, is it 1 or 2. If B, is it 3...

Hi I am having trouble with the below formula. The formula returns #value . I'm hoping someone can spot something that I can't see. =SUMIFS(((INDEX('Cash Flow items'!$C$4:$J$5,MATCH('Outflow Summary'!$B4,'Cash Flow items'!$B$4:$B$5,0),MATCH('Outflow Summary'!$C4,'Cash Flow...

Hi All, I am trying to automate mail sending process. Now, the code which I have is working fine. But I want to add more functionality to it. After ML.Display in the below code snippet, I want to hold on the flow of execution. ML.Display will display the mail which is ready. After that I want...

Hi all, i'd like to ask for any help for my request. Sheet1, my data in/out flow frequency for every week(updated once a week) Sheet2, my request. i need to process sequence & accurate: -by date, by time flow, by EP01IN/EP01OUT, EP02IN/EP02OUT.....(even more).... -Sheet2 is no necessary to...

Hi, This is a flow, (transportation, graph, etc.) problem below. Variables and their values are given in Columns A and B. Situations based on Variable 1 and Variable 2 are given at the D,E and F columns. The total flow must not be longer than 10. If so, it means overload and skip that step...

Hi Mr Excel - new user. In this project a property is being vested in a company (title transfer with out cost) thus no initial capital out lay. Positive cash flow revenue commences immediately. In the third year of ownership there is an obligation to leverage the assets value i.e. take out a...

Is there a way to sort 1 column in excel alapheticly and then numerically? This is for a flow in a warehouse. My flow goes 2a1.1, 2a1.2, 2a2.3, 2a3.4, 2a4.3, 2a5.3, 2a6.1, 2a7.3, 2a8.1, 2a9.3 2a10.1 and so on. The problem being when I sort alapheticly I doesn't sort it I the correct order. The...

Hi, I had an old template with a formula that doesn't seem to exist in Excel 2016. =CashFlowForecast($B$3,J$6,$F12,$H12,$G12,$E12,'Cash Curves'!$A$2:$E$403,$D12)-SUM($H12:I12) This formula allowed me to cash flow my budget by date and then by type (front-loaded, back-end loaded, linear and...