web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Get Items filter query

Power Automate

Answered

Get Items filter query

(0) Share

Report

Report

Posted on by Danny_Dicaprio

Hi Team

I'm having a filter query in my get items

First Iam splitting a text from its description from the MS Form

Compose =

split(outputs('Get_response_details')?['body/rebfcb7b61e644cbb9960039342c09c7e'], '(')[0]

once I split the text I'm filter that record in my sharepoint list

my filter formula is working for certain items in my sharepoint list and not for others

For the ones , which is not working , there will be square box at the end

I thought of may be because of extra space or some upper characters issue

The below one worked perfectly fine

Could anyone please let me know how to fix this issue

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (2)

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Danny_Dicaprio ,

Please try this expression in 'Compose'.

trim(split(outputs('Get_response_details')?['body/rebfcb7b61e644cbb9960039342c09c7e'], '(')[0])

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report
Copy link

Link copied!

HI @v-yetonggu-msft

thanks for the reply

it resolved !

could u please what was the issue with my function ?

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Danny_Dicaprio ，

Because the select option text content extracted by your split function sometimes contains extra spaces, and the values of the columns in your list do not contain spaces, this will cause Get items to sometimes filter out 0 records.

You can check if there are any extra spaces in your MS Form select option before '('.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft
Hi
Everyone

I have a text from my MS Form should be recorded in the Lookup Column in my share point list.

Since Lookup column values can only be stored in ID, Iam getting the ID of the text value from get items.

But the value is not getting displayed in the SharePoint List , it is Blank.

Could you please help me to fix the issue?

Was this reply helpful? Yes No

Join the conversation