Odata: filter a Get Items by month

(1) Share

Report

Posted on by Calcioscacchi

413

Hi there.

I have a sharepoint List where I have a datetime field and a calculated column called "Month" which just give me the number of the relative Month, and the number of the month is a numeric input of my filter (means that anytime I need to run the flow, I need to change the number of the target month inside the filter).

I need a flow to delete some records with a specific value of "Month".

I discovered that calculated rows are not a legit target for the OData Filter.

Any ideas to help me?

thanks!

Categories:

Business Process Flows

All responses (6)

Answers (0)

Calcioscacchi 413 on at

Like (1)

Report

Re: Odata: filter a Get Items by month

Yeah, I just filtered some data but this is the list:

The logic of the automation is quite simple:

-check all the rows with Mese = X (where I decide the value of X everytime, editing the automatio)
-delete them.
v-yetonggu-msft on at

Like (1)

Report

Re: Odata: filter a Get Items by month

Hi @Calcioscacchi ,

What does your SharePoint list look like?

Could you please provide a screenshot?

Can you be specific about the requirements you want to achieve?

I don't know if you want to delete the specified item based on the datetime column or the Month column.

Best Regards,

Sunshine Gu
Calcioscacchi 413 on at

Like (1)

Report

Re: Odata: filter a Get Items by month

Like this?
v-yetonggu-msft on at

Like (1)

Report

Re: Odata: filter a Get Items by month

Hi @Calcioscacchi ,

Could you please show me a screenshot of your current flow configuration parameters?

Best Regards,

Sunshine Gu
Calcioscacchi 413 on at

Like (1)

Report

Re: Odata: filter a Get Items by month

Yes.

But in a previous step, I want to test that the flow takes the correct rows. I think that build a flow and delete items without testing the filters is a bit too risky.
v-yetonggu-msft on at

Like (1)

Report

Re: Odata: filter a Get Items by month

Hi @Calcioscacchi ,

What do you want to achieve? Do you want to delete data based on a special month in the date and time column?

Best Regards,

Sunshine Gu