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

I want to check Status Column Value in each items in sharepoint

I have 10 items in my sharepoint each has status in the ACtion Column.

I want to check for all items whether Action is "Completed" then send mail.

S0 Condition should be applied to all items.

In Apply to each COndition tab its asking:

*Select an output from previous steps" .

I am getting only "value" in dynamic content.Trigger is failing if i add value.

2 REPLIES 2
Community Support Team
Community Support Team

Re: I want to check Status Column Value in each items in sharepoint

Hi @Anu,

 

Could you please share a screenshot of the flow you are working with?

Besides, would you please explain a bit for "I want to check for all items whether Action is "Completed" then send mail."?

Because using Apply to Each with a condition, it will send an Email for each item which met the condition.

If you would like to send only one Email with the Status Completed item in an HTML table, then we could take use the following way:

Obtaining a filtered SharePoint list based off a column

For Apply to each, the SharePoint list item fields should be added after specify the value under Apply to Each, see example:

17.PNG

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anu
Level: Powered On

Re: I want to check Status Column Value in each items in sharepoint

I Have a Column Status for Order which has 4 Values default New and others IN progress , Pending , Closed , Rejected.

I want to check for each & send respective mails to different PDL's.

so  should I make 4 conditions to chk like

Status=IN progress ->Mail1

Status=Pending ->Mail2

Status=Closed ->Mail3

Status=Rejected ->Mail4

 

So for this case-Because using Apply to Each with a condition, it will send an Email for each item which met the condition.

So only today's item which changed status only should send a mail.Is it feasible?

 

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

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!

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
Users online (5,953)