List for Count mails received

[frixel]

I try to make a list in sharepoint where i can seen when en how much mail i received.

It doesn`t work by me.

I read this and this but the go something wrong.

[v-zhos-msft]

Hi @frixel ,

It seems you want to record the number of the emails you have received.

I afraid you can update the list Id here.

From you Pic, it seems you want use the Id to record the number of the emails you have received.

However the Id field is used to get the extist items.

When you create a new item, the Id will increase 1 automatically.

So if you want use the ID to record the number of the emails.

I suggest you use the 'Create item' action here.

Or you can create a number column in the list with the Starting value as 0.

When a new email arrives, update the value (add 1).

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[frixel]

Hi @v-zhos-msft 

Thanks for your response.

I have this error when i do that.

And so is my list, is that correct?

[v-zhos-msft]

Hi @frixel ,

You should set the Title value as 0 at the beginning.

As the pic shown, you just has one item in your list.

So you can use the 'Get item' here.

You can get the ID value via +add column> show/hide columns 

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[frixel]

Hi @v-zhos-msft 

I push the Apply button and then i see the ID in the list.

but when I reload the page, the ID is no longer visible.

[v-zhos-msft]

Hi @frixel , 

The ID column is hide as default.

So I suggest you create another column to record the amount of emails.

The solution was shown above.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[frixel]

@v-zhos-msft 

I`am so sorry but, i can't get away with that list at all.
Can you show what that list should look like and what it will contain when that email has counted?

I have again always this error.

[v-zhos-msft]

Hi @frixel ,

My list is like below:

The 'Acoumt emails' column is used to record the numbers of emails.

You don't need care about the ID value, it is just used to get the item.

The expression in the update action is:  add(int(body('Get_item')?['Acoumtemails'],1))

When a new email arrives, the 'Acoumt emails' value will add 1.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[frixel]

I do really not know what I am doing wrong but still error message.

[frixel]

These two IDs must match?

[v-zhos-msft]

Hi @frixel ,

I suggest you use the 'Get item' instead of 'Get items' here.

Of couse, you need match the Id in the Flow to the List ID to get the specific item.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[frixel]

Hi @v-zhos-msft 

I have the same ID`s but stil i don`t have it working 

[v-zhos-msft]

Hi @frixel ,

Sorry for the mistake.

The expression shoud be: add(int(body('Get_item')?['Emails']),1)

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[frixel]

hopeless 

[v-zhos-msft · Accepted solution]

Hi @frixel ,

You should set the 'Emails' column value as 0 at the beginning.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.