Unanswered

Microsoft Flow: SharePoint list calculated column not supported

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I've got this sharepoint list where there's a calculated column that, depending on the input, says "Errors Found" or "Errors Not Found". As I can't use it as a Odata Filter, what options do I have?

Basically I want a flow to run every day at 6pm, that filters the sharepoint list by "Errors Found" and sends an email to a team with all the items that match this condition.

Kind Regards,

Cátia

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

@Anonymous , start with a Recurrene schedule and set it to run every 1 day at 18 hours in your timezone. Then you get the SharePoint items and just need to add a Condition control, select the calculated column from the dynamic content and set it to is equal to Errors Found. Then in the Green If Yes channel add a Send an email (v2). You can leave the red If no channel empty.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
Verified answer

v-zhos-msft on at

Like (0)

Report

Hi @Anonymous

It seems you want to send all the items with "Errors Found" value in one email.

First I created a calculated column named 'Error' in the list.

I have made a flow for your scenario, please check it for a reference.

The expression in the 'Create CSV table' is:

item()?['Title']

item()?['{Link}']

You can add the other columns of your list.

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.

Was this reply helpful? Yes No