Filtering the data based on current user name

[Sai47]

Hi , 

I have a scenario when the app opens the data filtered should be of current user,

The function used in itemgallery is as below

Search(

    Filter(

        Datasource,

        (IsBlank(ABDrop.Selected.Result) || AB = ABDrop.Selected.Result) && (IsBlank(MADrop.Selected.Result) || 'MA= MADrop.Selected.Result) && (IsBlank(KVDrop.Selected.Result) || 'KV’ = KVDrop.Selected.Result) && (IsBlank(SPDrop.Selected.Result) || 'SP' = SPDrop.Selected.Result) && (IsBlank(PDrop.Selected.Result) || 'P' = PGroupDrop.Selected.Result)   ),

    SearchBox.Text,

    "Itemdescp",

    "ProdID");

In other table which is user list table there is MA Column and User name column and I created look up column based on the datasource table so I can use username column in MA filter function

MAfilter=Distinct(filter(userlist,’primary name column’=user().FullName),MA)

I got the MA’s based on logged user when I filter MA but when I open the app the data also has to be filtered based on the user?

Please let me know what can be done in item gallery ?

Thankyou.

[BCBuizer]

Hi @Sai47 ,

This can be achieved by adding an extra condition to the Filter function:

Search(
    Filter(
        Datasource,
        IsBlank(ABDrop.Selected.Result) || 'AB' = ABDrop.Selected.Result,
		IsBlank(MADrop.Selected.Result) || 'MA' = MADrop.Selected.Result,
		IsBlank(KVDrop.Selected.Result) || 'KV’ = KVDrop.Selected.Result,
		IsBlank(SPDrop.Selected.Result) || 'SP' = SPDrop.Selected.Result,
		IsBlank(PDrop.Selected.Result)  || 'P' = PGroupDrop.Selected.Result,
		'MA' in Filter(
			userlist,
			’primary name column’=user().FullName
		).MA.Value			
	),
    SearchBox.Text,
    "Itemdescp",
    "ProdID"
);

Since you are already using the Search function, the use of the in operator shouldn't pose any additional delegation issues.

Ps. I tidied up the filter conditions a bit which didn't change the functionality, but does make it easier to read.

[Sai47]

Hi,

Thanks for the response,

When I keep 

'MA' in Filter(
			userlist,
			’primary name column’=user().FullName
		).MA.Value	

After selecting 'MA' in Filter(Userlists,  , it is showing Delegation issue when continuing the condition as Search as the invalid arguments and unable to get the column name(primary name column) to select it.

Please suggest me.

[BCBuizer]

Hi @Sai47 ,

Apologies, but I don't understand what you are saying. Can you please clarify what data source you are using (Dataverse / SharePoint list / Other) and post the error text(s) you receive?

[gcmfaizan]

@Sai47 ,

You can achieve this functionality by set a variable on start like:

Set(gVarUserMa, Lookup(userlist, 'primary name column' = User().FullName).MA)

and on Item property of gallery use this formula hope this formula not shown you the deligation warning:

Search(
    Filter(
        Datasource,
        (IsBlank(ABDrop.Selected.Result) || AB = ABDrop.Selected.Result) &&
        (IsBlank(MADrop.Selected.Result) || 'MA' = MADrop.Selected.Result) &&
        (IsBlank(KVDrop.Selected.Result) || 'KV' = KVDrop.Selected.Result) &&
        (IsBlank(SPDrop.Selected.Result) || 'SP' = SPDrop.Selected.Result) &&
        (IsBlank(PDrop.Selected.Result) || 'P' = PGroupDrop.Selected.Result) &&
        MA = gVarUserMa  
    ),
    SearchBox.Text,
    "Itemdescp",
    "ProdID"
)

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!

[Sai47]

Hey this is working okay but if the MA contains two or three in list for single user, data is showing only first MA rows.

[BCBuizer · Accepted solution]

Hi @Sai47 ,

Please try:

Search(
    Filter(
        Datasource,
        IsBlank(ABDrop.Selected.Result) || 'AB' = ABDrop.Selected.Result,
		IsBlank(MADrop.Selected.Result) || 'MA' = MADrop.Selected.Result,
		IsBlank(KVDrop.Selected.Result) || 'KV’ = KVDrop.Selected.Result,
		IsBlank(SPDrop.Selected.Result) || 'SP' = SPDrop.Selected.Result,
		IsBlank(PDrop.Selected.Result)  || 'P' = PGroupDrop.Selected.Result,
		'MA' in Filter(
			userlist,
			’primary name column’=user().FullName
		).MA			
	),
    SearchBox.Text,
    "Itemdescp",
    "ProdID"
);

[gcmfaizan]

@Sai47 Yes you are right it returns single-user records. Update your formula as below:

Search(
 With(
        {
            tempVarMA: Lookup(userlist, 'primary name column' = User().FullName).MA
        },
    Filter(
        Datasource,
        (IsBlank(ABDrop.Selected.Result) || AB = ABDrop.Selected.Result) &&
        (IsBlank(MADrop.Selected.Result) || 'MA' = MADrop.Selected.Result) &&
        (IsBlank(KVDrop.Selected.Result) || 'KV' = KVDrop.Selected.Result) &&
        (IsBlank(SPDrop.Selected.Result) || 'SP' = SPDrop.Selected.Result) &&
        (IsBlank(PDrop.Selected.Result) || 'P' = PGroupDrop.Selected.Result) &&
        MA = tempVarMA.MA  
    ),
    SearchBox.Text,
    "Itemdescp",
    "ProdID"
)

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!