Odata: filter a Get Items by month

Like (1) Share

Report

Posted on 1 Jul 2024 09:17:27 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

I have the same question (0)

All responses (6)

Answers (0)

Calcioscacchi 413 on 02 Jul 2024 at 12:00:49

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.

Was this reply helpful? Yes No
v-yetonggu-msft on 02 Jul 2024 at 00:58:18

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

Was this reply helpful? Yes No
Calcioscacchi 413 on 01 Jul 2024 at 09:46:02

Like (1)

Report

Re: Odata: filter a Get Items by month

Like this?

Was this reply helpful? Yes No
v-yetonggu-msft on 01 Jul 2024 at 09:40:34

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

Was this reply helpful? Yes No
Calcioscacchi 413 on 01 Jul 2024 at 09:38:13

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.

Was this reply helpful? Yes No
v-yetonggu-msft on 01 Jul 2024 at 09:24:19

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

Was this reply helpful? Yes No