cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

List for Count mails received

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.

 

flow14.png

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @frixel ,

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

Capture1.PNG

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.

 

View solution in original post

14 REPLIES 14
Solution Sage
Solution Sage

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.

Capture10.PNG

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

Capture13.PNG

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.

 

Hi @v-zhos-msft 

 

Thanks for your response.Cat Happy

 

I have this error when i do that.

 

Flow6.png

 

And so is my list, is that correct?

 

Flow7.png

 

 

Hi @frixel ,

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

Capture14.PNG

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 

Capture15.PNGCapture16.PNG

Capture17.PNG

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.

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.

 

 

Flow8.pngFlow9.png

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.

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

Flow10.png

Hi @frixel ,

My list is like below:

Capture2.PNG

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.

Capture3.PNG

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.

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

 

Flow11.pngFlow12.png

These two IDs must match?

 

Flow13.png

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.

Hi @v-zhos-msft 

 

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

 

flow15.png

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.

 

hopeless 

 

flow16.png

Hi @frixel ,

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

Capture1.PNG

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.

 

View solution in original post

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (58,302)