Answered

ODATA FILTER QUERY

(0) Share

Report

Posted on by Tmeneses

Hi, I have flow but it gives me a bad request error on the get items. please see attached photo of my flow. Kindly let me know what is wrong with this flow. Thank you so much. Screenshot 2024-04-03 133353.png Screenshot 2024-04-03 133416.png

All responses (18)

Answers (1)

Tmeneses 20 on at

Like (0)

Report

Re: ODATA FILTER QUERY

it's works now, thank you very much :)))))))))
Verified answer

v-yueyun-msft on at

Like (0)

Report

Re: ODATA FILTER QUERY

Hi , @Tmeneses

What's the code you put here?

In your side , you need to put in my thought:
item()?['CAR_x0023_0']

item()?['Status']?['Value']

Can you show me your screenshot , you put in this Create Html Table?

Best Regards,

Yueyun Zhang
Tmeneses 20 on at

Like (0)

Report

Re: ODATA FILTER QUERY

aplogies for so many questions.
Tmeneses 20 on at

Like (0)

Report

Re: ODATA FILTER QUERY

I followed your instructions to add custom column name. I received email looks below, the data for CAR # and current status is not provided.
v-yueyun-msft on at

Like (0)

Report

Re: ODATA FILTER QUERY

Hi , @Tmeneses

If you want to custom column Name in your side , you can click this:

item()?['ID']

item()?['fieldName']

You need to replace the fieldName in your side!!! How to find it , you need to see the output of your "Get items" action :

So that you can just extract the column you need in html Table.

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang
Tmeneses 20 on at

Like (0)

Report

Re: ODATA FILTER QUERY

When i run the data this is the email I received hehe. the data is.
What if I only want to received table with the CAR# and Open Status details? What do I need
v-yueyun-msft on at

Like (0)

Report

Re: ODATA FILTER QUERY

Hi , @Tmeneses

Your Select action parameter is wrong in your side. You do not need to use the Select action in your side .

In the above action, you can refer to this flow：

If you want to custom column Name in your side , you can click this:

item()?['ID']

item()?['fieldName']

You need to replace the fieldName in your side!!! How to find it , you need to see the output of your "Get items" action :

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang
v-yueyun-msft on at

Like (0)

Report

Re: ODATA FILTER QUERY

Hi , @Tmeneses

You can keep the balnk in your Filter query property and check if this flow can return data in your email.

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang
Tmeneses 20 on at

Like (0)

Report

Re: ODATA FILTER QUERY

here's the result, run's flow failed and
Thank you,
v-yueyun-msft on at

Like (0)

Report

Re: ODATA FILTER QUERY

Hi , @Tmeneses

The Filter Query is used to filter the data in SharePoint , if you put the "CAR_x0023_0 eq null" in your filter query property.

It will just return the [CAR_x0023_0]=null rows. But in your screenshot , there is no rows meet this condition.

So you do not put anything in your side in the filter query property in my understand.

Best Regards,

Yueyun Zhang