1

I'm working with MS Flow / Form and I'm trying to show the amount of time a single user submits something into Sharepoint. (see below)

Example of output

Is this possible through a formula?]

Thanks.

4
  • I've just posted an answer, but read your question again. I'm not sure what you mean by increment / auto-increment...
    – Tally
    Commented Jul 10, 2019 at 10:35
  • I want it to show the number of times the same value was submitted - incrementing in a different column.
    – Michael S
    Commented Jul 10, 2019 at 10:50
  • Please see updated Answer
    – Tally
    Commented Jul 10, 2019 at 13:30
  • Hi Michael S, I updated my Answer, did you get this to work??
    – Tally
    Commented Aug 19, 2019 at 11:44

1 Answer 1

0

Do you want to count the number of items with the same email address? I might have misunderstood your question...

A really quick answer might be to create a view, then use the Group By setting - group by email address. This groups all items submitted from an email address and totals up the number of items they've submitted:

So if [email protected] has submitted 5, it would look like this:

[email protected] (5)

While if another email address submitted 3, it'd look like this:

[email protected] (3)

Like I said, a quick answer, but maybe you have reasons for needing a calculation/formula.

Updated - following your comments

In which case you can use a calculated column - see MS guidance here

enter image description here

So in your case you'd make a new calculated column and adapt the formula to fit your column names - call the new column CountEmail.

Microsoft example: =IF([Column1]="Vietzen", "OK", "Not OK")

Your example: =IF([Email Address]="[email protected]", "1", "0")

The CountEmail column will show a 1 in the 5 items with the [email protected] email address.

Next you need to find a way of counting all the "1" values in the CountEmail column.

countemail screen shot

So, I've got you part way. However, I believe you'll need to use a 'nested IF statement' in your calculated column, which is more complicated. It's more complicated because you have more variables in your calculation - you want the calculation to be able to handle values x, y and z (x, y and z = the different email addresses. Please see here for an example of a nested IF statement.

2
  • I want another column to show the number of entries so I can refer back to it in MS Flow to help with a report. Unless it is possible to skip the '[email protected]' and only bring back '(3)' or '(5)' etc
    – Michael S
    Commented Jul 10, 2019 at 10:36
  • Another way to do this would be to use variables - I've not used Flow, but if it is similar to the way Sharepoint Designer works, you can use variables in a workflow to count the number of e.g. [email protected] values. Your variable would be the email address, it would count the email and paste this value in to an EmailCount field.
    – Tally
    Commented Jul 10, 2019 at 13:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.