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

Categories:

Building flows

I have the same question (0)

All responses (18)

Answers (1)

Sort by

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Tmeneses

You need to delete the FIlter query parameter in your side.

This is not Valid, for the examples , you can refer to :
Power Automate SharePoint Get Items Filter Query + 12 Examples - Enjoy SharePoint

And in your Order By , you need to check if your "CAR#" is the internal column Name in your SharePoint List.

Get Internal Name of a Column in SharePoint Online using PowerShell - SharePoint Diary

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

Was this reply helpful? Yes No
Tmeneses 20 on at

Like (0)

Report
Copy link

Link copied!

Hi Thank you for your response , i already fixed the Odata problem thank you.
My flow works okay up but the only problem is the HTML table. it's doens't appear in the email.the result after I run the flow

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Tmeneses

Thanks for your response! As your screenshot , you can see the "Get items" return blank array in your side.

You need to check why your "Get items" return blank in your flow run history.

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

Was this reply helpful? Yes No
Tmeneses 20 on at

Like (0)

Report
Copy link

Link copied!

Hi Thank you, this is my get items looks like? what do I need to change?

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Tmeneses

In your screesnshot, you put this in Filter Query :
CAR_x0023_0 eq ''

Do you mean you want to filter the blank value in your [CAR_x0023_0] column?

Can you try to use this code here:
CAR_x0023_0 eq null

And you can see the output in your flow run history to check if it has data return in 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

Was this reply helpful? Yes No
Tmeneses 20 on at

Like (0)

Report
Copy link

Link copied!

hello this is my share point list looks looks like and I need to send html table of CAR# as an example on my email. The CAR# internal column name is CAR_x0023_0 that's why I used it instead of CAR#. and attached herewith is the output screenshot results. What do I need to get the data on my sharepoint list?

Was this reply helpful? Yes No
Tmeneses 20 on at

Like (0)

Report
Copy link

Link copied!

I already tried to use the code CAR_x0023_0 eq null but my email appears still blank.

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Tmeneses

If you just want to get the data from SharePoint List , you need to delete all the code in your Filter Query property.

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

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Tmeneses 20 on at

Like (0)

Report
Copy link

Link copied!

here's the result, run's flow failed and
Thank you,

Was this reply helpful? Yes No