Power Platform Community Forum Thread Details

Hi everyone,

i have build an app based on the video below:

Editable Grid in Power Apps | SharePoint List - Bing video

In addition to that i created one excel list with all the login information including Username, Password and Processteam. And created a Startscreen to Login.

My Grid looks like that:

Prozess =Processteam

I want only the members of the team to be able to make changes in its associated columns. For Example only Members of Konfektion should be able to make changes in the Row where "Konfektion" is the Process. If a Member of Konfektions logs in and wants to edit the grid only the Row of Konfektion should be editable.

I hope i explained what i want in the right way and i hope that one of u can help me.

Thanks in advance ❤️

My edit button:

If(
varAngebotskalkulation;
If(
!IsBlank(
LookUp(
colTabelle;
Title = Blank() || Title = ""
)
);
Notify(
"Bitte die fehlenden Pflichtfelder ausfüllen";
NotificationType.Error;
2000
);
Patch(
Angebotskalkulation;
UpdateIf(
colTabelle;
Erstellt = Blank();
{ID: Blank()}
)
);;
Remove(
Angebotskalkulation;
coldelete
);;
Notify(
"Tabelle wurde aktualisiert";
Success;
2000
);;
Clear(coldelete);;
Select(Button3);;
Set(
varAngebotskalkulation;
!varAngebotskalkulation
)
);
Set(
varAngebotskalkulation;
!varAngebotskalkulation
)
)

my Button3:

ClearCollect(colTabelle;Filter(Angebotskalkulation;StartsWith(Title;TextInput2.Text)&&
Version1=TextVersion.Text||StartsWith(Title;TextInput2.Text)&&IsBlank(TextVersion.Text)))

Categories:

Building Power Apps