Searching based on custom name with space

(0) Share

Report

Posted on by Mahesh005

My Requirement is to search outlook based employee name column i.e. Tendulkar,Sachin

I want to search like Tendulkar space Sachin i.e Tendulkar Sachin.

Please provide Canvas app code to achieve above functionality.

Thanks & Regards,

Mahesh

Categories:

Power Platform Build Tools

I have the same question (0)

All responses (9)

Answers (0)

v-bofeng-msft on at

Like (0)

Report
Re: Searching based on custom name with space

Hi @Mahesh005 ,

You could use Substitute to replace the ',' with ' '.

Substitute(TextInput1,","," ")

Best Regards,

Bof

Was this reply helpful? Yes No
Mahesh005 36 on at

Like (0)

Report

Re: Searching based on custom name with space

Hi @v-bofeng-msft

When i do that with add column. it is throwing error in the on check and on uncheck patch formulae like added column is missing in the following collection.

Thanks,
Mahesh

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Re: Searching based on custom name with space

Hi @Mahesh005 ,

Could you please show me your formula ?

Best Regards,

Bof

Was this reply helpful? Yes No
Mahesh005 36 on at

Like (0)

Report

Re: Searching based on custom name with space

I wrote formulae in gallery items as follows
filter(search(addcolumns(collectionname,"Columnname",Substitue(EmployeeName,",",""))txtempname.text,"Columname")
Then it is throwing error in the below patch syntax like the added column does not exist or invalid arguemnts

Patch(collectionname,thisitemm{ isactive: true})

Was this reply helpful? Yes No
Mahesh005 36 on at

Like (0)

Report

Re: Searching based on custom name with space

Itried as below, but still throwing error
patch(dropcolumns(collectionname,"Columnname",thisitem,{IsSelect:Active},)

Thanks & Regards
Mahesh

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Re: Searching based on custom name with space

Hi @Mahesh005 ,

Search( AddColumns(collectionname,"Columnname",Substitue(EmployeeName,",","")), txtempname.text, "Columname" )

Best Regards,

Bof

Was this reply helpful? Yes No
Mahesh005 36 on at

Like (0)

Report

Re: Searching based on custom name with space

it is working but When i do addcolumns it is trhowing error patch on check and uncheck.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Re: Searching based on custom name with space

Hi @Mahesh005 ,

Please try:

Filter( collectionname, Substitue(txtempname.text," ",",") in Columname || txtempname.text in Columname )

Patch

Patch(collectionname,ThisItem,{IsSelect:Active})

Best Regards,

Bof

Was this reply helpful? Yes No
Mahesh005 36 on at

Like (0)

Report

Re: Searching based on custom name with space

No error but not working.

Was this reply helpful? Yes No