Edit Gallery expect Completed Status should list

(0) Share

Report

Posted on by Jawaharprem

263

Hi All,

I have created a Edit form Gallery it is done perfectly but my query is under header Mail_Status <> "Completed" data should list in Edit gallery it is possible

this below query only list of their user upload data only. its possible to add the above req on same.

ClearCollect(colGridData,Filter(Gobal_Master_Data_EU,StartsWith(Requestor_Name,TextInput2.Text)
&& Allocated_To=User().FullName));

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 154,399 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Jawaharprem ,

See below - the reason for the split is that <> is not Delegable

With( { wData: Filter( Gobal_Master_Data_EU, StartsWith( Requestor_Name, TextInput2.Text ) && Allocated_To = User().FullName ) }, ClearCollect( colGridData, Filter( wData, Mail_Status <> "Completed" ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Jawaharprem 263 on at

Like (0)

Report
Copy link

Link copied!

Hi sir,
Thank you for your time,
one error list on <>
error mentioned :- "Incompatible types of comparison. These types cant be compared:Record,Text."

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,399 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@Jawaharprem ,

I simply copied your requirement posted for that past - if this is a Choice column

With( { wData: Filter( Gobal_Master_Data_EU, StartsWith( Requestor_Name, TextInput2.Text ) && Allocated_To = User().FullName ) }, ClearCollect( colGridData, Filter( wData, Mail_Status.Value <> "Completed" ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Jawaharprem 263 on at

Like (0)

Report
Copy link

Link copied!

Hi sir,
Yes, This is a Choice Column.

Was this reply helpful? Yes No