cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Elitezone
Post Prodigy
Post Prodigy

Filter - show only my propositions

Hello, 

 

In my gallery I have a label:

 

"List of propositions: "&With({wZone:IdeaBox_1};CountRows(wZone))

 

It shows all of records in IdeaBox_1 (sharepoint list).

 

I created another gallery that shows only my records, and I tried to modify this label to count only my records.

Where am I doing a mistake?

 

 

"List of propositions: "&With({wZone:IdeaBox_1};CountRows(wZone) & 'Utworzone przez'.Email=User().Email))

 

Utworzone przez = MadeBy in polish.

I am getting errors:

Invalid name and unexpected usage of signs.

1 ACCEPTED SOLUTION

Accepted Solutions
v-jefferni
Community Support
Community Support

Hi @Elitezone ,

 

Do you want to count records in the table of IdeaBox_1 and display the result in the Label?

If you do, please change the formula to:

 

"List of propositions: "&With({wZone: Filter(IdeaBox_1, 'Utworzone przez'.Email=User().Email)};CountRows(wZone))

 

The Filter() function filters all records belong to you to be the data source of With() function.

 

In addition, there might be a delegation warning for the User().Email, you’d better use a variable to replace it. Set below variable on the OnVisible of the screen:

 

Set(varUser,User().Email) 

 

Then the formula would be:

 

"List of propositions: "&With({wZone: Filter(IdeaBox_1, 'Utworzone przez'.Email=varUser)};CountRows(wZone))

 

 

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution  to help the other members find it.

View solution in original post

2 REPLIES 2
v-jefferni
Community Support
Community Support

Hi @Elitezone ,

 

Do you want to count records in the table of IdeaBox_1 and display the result in the Label?

If you do, please change the formula to:

 

"List of propositions: "&With({wZone: Filter(IdeaBox_1, 'Utworzone przez'.Email=User().Email)};CountRows(wZone))

 

The Filter() function filters all records belong to you to be the data source of With() function.

 

In addition, there might be a delegation warning for the User().Email, you’d better use a variable to replace it. Set below variable on the OnVisible of the screen:

 

Set(varUser,User().Email) 

 

Then the formula would be:

 

"List of propositions: "&With({wZone: Filter(IdeaBox_1, 'Utworzone przez'.Email=varUser)};CountRows(wZone))

 

 

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution  to help the other members find it.

View solution in original post

@v-jefferni 

Great help! And nice tip with OnVisible.

After some tests I believe that it is OK!

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (68,850)