User access look up from sharepoint list

(1) Share

Report

Posted on by safiranrd

Good Day Everyone,

I want to create a different navigation for a button in power apps based on the user access (PIC and user). I have created a sharepoint list containing PIC email and contact person like this:

And I want to create a 2 different navigations from this button for PIC (Tracking_PIC) on the list and user (Tracking)

Im trying to use if and look up formula but it doesnt work

What formula can i use to create a different navigations for this button? Any kind of assistance is really appreciate, thank you!

Categories:

Connectors

Using Apps Using Formulas

General Questions

Untitled.png

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

CU05110754-0 4,982 Super User 2025 Season 2 on at

Like (2)

Report
User access look up from sharepoint list

Hey safiranrd,

Could you try this?
If( RountRows( LookUp( 'HR PIC', Email=USer().Email ), )>0, Navigate(Tracking), Navigate(Tracking_PIC) )

This will return a warning (Delegation) that you can ignore, since this formula will search for only one record.

Let me know if this helped you.

If it did please consider accepting this answer as Solution, so others can find the answer as well.

If it helped you in any other way or form consider giving it a like.

Was this reply helpful? Yes No
WarrenBelz 151,751 Most Valuable Professional on at

Like (1)

Report
User access look up from sharepoint list

This will do the same thing without the Delegation issue
If( !IsBlank( LookUp( 'HR PIC', Email = User().Email ).Email ), Navigate(Tracking), Navigate(Tracking_PIC) )

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
safiranrd 48 on at

Like (1)

Report

User access look up from sharepoint list

Hi @WarrenBelz and @DBO_DV,

Thanks for your suggestion, i have tried both of the formula you gave but it still doesnt work. I think my powerapps cant read = symbols. Is that possible?

Was this reply helpful? Yes No
CU05110754-0 4,982 Super User 2025 Season 2 on at

Like (1)

Report
User access look up from sharepoint list

Hey Safirand,

Sorry i Missspelled a Word.

If( CountRows( LookUp( 'HR PIC', Email=USer().Email ), )>0, Navigate(Tracking), Navigate(Tracking_PIC) )

Could you tell us what language you are using in Power apps?

Could you also tell us what error message you are getting back?

If its another language then English it might be possible, that you have to switch the ',' with ';' and the ';' with ';;' so it would look like this:

If( CountRows( LookUp( 'HR PIC'; Email=USer().Email ); )>0; Navigate(Tracking); Navigate(Tracking_PIC) )

Let me know if this helped

Was this reply helpful? Yes No
WarrenBelz 151,751 Most Valuable Professional on at

Like (1)

Report

User access look up from sharepoint list

Try a capital U in LookUp

Was this reply helpful? Yes No
safiranrd 48 on at

Like (1)

Report

User access look up from sharepoint list

Hi @WarrenBelz and @DBO_DV

I Tried to correct the spelling and use another method but it still doesnt work

Was this reply helpful? Yes No
WarrenBelz 151,751 Most Valuable Professional on at

Like (1)

Report

User access look up from sharepoint list

It is telling you that Email is not the valid field name.

Was this reply helpful? Yes No
safiranrd 48 on at

Like (1)

Report

User access look up from sharepoint list

I think so, but my column title name in sharepoint list is "Email"

Was this reply helpful? Yes No