cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
frixel
Level: Powered On

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
v-zhos-msft
Level 10

Re: List for Count mails received

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
v-zhos-msft
Level 10

Re: List for Count mails received

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.

 

frixel
Level: Powered On

Re: List for Count mails received

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

 

 

v-zhos-msft
Level 10

Re: List for Count mails received

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.

frixel
Level: Powered On

Re: List for Count mails received

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

v-zhos-msft
Level 10

Re: List for Count mails received

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
Level: Powered On

Re: List for Count mails received

@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

v-zhos-msft
Level 10

Re: List for Count mails received

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.

frixel
Level: Powered On

Re: List for Count mails received

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

 

Flow11.pngFlow12.png

frixel
Level: Powered On

Re: List for Count mails received

These two IDs must match?

 

Flow13.png

v-zhos-msft
Level 10

Re: List for Count mails received

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
Level: Powered On

Re: List for Count mails received

Hi @v-zhos-msft 

 

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

 

flow15.png

v-zhos-msft
Level 10

Re: List for Count mails received

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
Level: Powered On

Re: List for Count mails received

hopeless 

 

flow16.png

v-zhos-msft
Level 10

Re: List for Count mails received

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
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,609)