Forum Discussion
Solved
Accessing Microsoft Flow in SharePoint "Classic" Interface.
Our SharePoint online was in Modern Interface for some time and during that time a user created a workflow using the 'Microsoft Flow' functionality (Flow feature was accessed from within the SharePoi...
I finally understand what you want to do and believe you can achieve it by using structured references and an OFFSET function to pick-up the number from the row below.
In E2 the formula becomes:
=[@[Amt Added]]+[@[Amt Withdrawn]]+[@Return]+OFFSET([@[Current Value]],1,0)and in F2:
=[@Return]+OFFSET([@[VOT Amt]],1,0)Make sure that these have filled down all the way to the bottom of the table.
When you now insert row 3, both formulas will auto-complete in the new row. See attached.
As to why the initial formula doesn't work, take a look at the formulas before you insert row 3.
From the start the formulas in E2 and F2 refer to cells E3 and F3. Insert row 3 and the references will update to E4 and F4 (i.e. two rows down), just as one would expect. The formulas on what is now row 4, still reference E5 and F5. I.e. only one row down. The same for all rows down the table.
Columns E and F now will no longer auto-complete as you have inconsistent formulas in them. Row 3 will be left blank and, the formulas in row 2 are wrong.
Yes, the user who created the flow should see it in the Flow portal....as you have said, it's not possible to access to Flow from the classic SPO experience for both lists and document libraries
Thanks Juan.
1) I was wondering if the Flows are tied to a particular person creating the Flow then how do we handle situations where there are changes to SharePoint Admin personnel. How do we maintain those Flows.
2) Also for a simple Flow where we send an email on creating a list item, the email going out has the email of the person who created the Flow (unlike in traditional Workflows where the "site" is mentioned as sender like "Team Site <no-reply@sharepointonline.com>"). Is there a way to have similar sender address in Flows.
3) The traditional Workflows allow us format the contents of email using simple html code. Is that something we can do in Flow as well?
Thanks for your valued inputs.
- Hi Vivek,
Just my two cents here:
1) You can share your workflows with others, so you could deal with a situation when there are changes in the personnel by means of this feature
2) AFAIK, this is something you cannot configure in Flow actions to send e-mail
3) You can already do this adding HTML code in the body property of the e-mail action
