Filter ,With Used For Location and User comparision Still In error

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (9)

Sort by

Verified answer

Kameshm05 310 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,
Can you please explain more about this code or your business need? From my understanding, there is one is there in Sort Syntax. below is the correct syntax for sorting. Anyway, there is another issue also. Please explain more about your business need.

Thanks
Sort(vList,Modified,Descending)

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This my Emplyoee Table
THis My Holiday List table

I need to Show Based on User login and location wise Holiday list
Example-If user belongs to India Gallery will show Only India List And User belongs to Singapore THen it will show Only Singapore holiday

Was this reply helpful? Yes No
Verified answer

Kameshm05 310 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @Anonymous .
Can you please share the employee column name and column type in the Employee Table?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It Showing In Screenshot same i have for both table

Was this reply helpful? Yes No
Verified answer

Kameshm05 310 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

I assume the alias name is the employee column and the datatype is "Single line of text". My suggestion is
With({userLoc:LookUp('<EmployeeTableName>'),AliasName = User().FullName,Location)},Filter('<HolidayTable',Location = userLoc))

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Its Showing Error

Was this reply helpful? Yes No
Verified answer

Kameshm05 310 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

With({userLoc:LookUp('Employee Tables'),AliasName = User().FullName,Location)},Filter('Holiday Lists',Location = userLoc))

This is the correct syntax, you added extra bracket in Lookup

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

NO Error But Still No data is showing

I used This Way also Its shwoing error i think with is for shrepoint not for dataverse

Was this reply helpful? Yes No
Verified answer

Kameshm05 310 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

The problem is with the alias name comparison with the currently logged user. The best practice is to compare the mail value of the user rather than the display name. so please compare the user email to the user display name. Anyway, the syntax is correct so you have to check the right condition. If you find any email column or person column, please user the column for comparison.
Thanks

Was this reply helpful? Yes No