Answered

Hide Edit form of the LineItem to User login in Expenses app

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

Hope you are doing well,

I'm currently working on my Expenses app, want to hide edit form, so that the person logged in can only see they own LineItems only.

Thanks,

Monisha

Categories:

Building Power Apps

I have the same question (0)

All responses (21)

Answers (1)

Sort by

Bipin D365 971 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

You would need to do couple of changes to achive your requirement -
1. App Onstart -> ClearCollect LineItems2 add EmailAddress field in collection
{Title: "Lodging", ID: "1", Date: DateAdd(Now(), -5, Months), Category: "Business Needs", Cost: 1400, ReportID: "4", Description: "Lodging throughout trip", Email:"bipinshan@bipininfysolution.onmicrosoft.com"}
2. While Adding Line Item on click of Save button you would need to set Email Address User().Email
Email:User().Email
3. Filter gallery by logged in user to show line item created by logged in user
Filter(LineItems2,ReportID = Text(SelectedReport2.ID), Email=User().Email)

Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @bipinshan,

Thanks for responding, could you be more clear the comments please.
Thanx,
Monisha

Was this reply helpful? Yes No
nickellis74 432 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
I think @bipinshan's suggestion is a bit over complex. Assuming the underlying data is SharePoint, simply set the gallery data source to
Filter('SharePoint Data Source','Created by'.Email = User().Email)
The gallery will then only show the records created by the logged in user.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @nickellis74,

Thanks for responding, still I get error.
Kindly help me please.

Thanx,
Monisha

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @nickellis74',

I'm getting error like this.

Was this reply helpful? Yes No
Himanshu_90677 416 on at

Like
a
(1)

Report
Copy link

Link copied!

In the Onvisible property of screen
Set(editformvisible, false)
Make editform visible property to visibleeditform
And then
Add this
Set(visibleeditform, true);
When you want to show this form

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CNT,@StalinPonnusamy ,

I need help to solve this below error please,
Thanks,
Monisha

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous 'Created By' B - Should be in Caps

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CNT,
Thanks for responding,
Im still getying same error.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Filter(IssueTracker, 'Created By'.Email=User().Email)

Reproducing your error (When use 'Created by' instead of 'Created By'

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No