sharepoint online – PowerApps gallery to form, how do i disable SAVE button when Form is in view mode?

I am not a coder, but trying to understand the logic and write the correct formula in PowerApps.

When I select ‘Edit’ from my ‘Gallery1’, it opens my ‘BuildForm’ screen in Power Apps.
I want the SAVE button on my ‘BuildForm’ screen to DISABLE when viewing the form.

Right now I have my SAVE button DisplayMode control set to:

If(BuildForm.Valid,DisplayMode.Edit, DisplayMode.Disabled)

It is disabled until the form is fully completed by the user.

How do I tell it to also disable the SAVE button when someone is only Viewing the information in the BuildForm?

Filter User().email from Sharepoint in Powerapps

I have gallery which using below formula to filter from Master , now i have another list Name user matrix where i have entries like below :

Title    Admin (Single line Text column )
Test1   Ashok.kumar@XXX.com;"AShok.Kumar2@XXX.com;AShokkumar3@XXX.com 
Test2   kumar@XXX.com;"Kumar2@XXX.com;kumar3@XXX.com 

Now how can I add additional filter in below formula so current user belongs to Test1 Admin it will show the items in gallery else not

If(
     showAll = "All",
    Sort(Filter (Master, ((IntermediateStatus.Value="Submitted" && AttorneyFor.Value="Approved by Manager")||IntermediateStatus.Value="Approved by Supervisor"||IntermediateStatus.Value="Approved by VP")),ID,Descending),
    showReport = "Report",
Sort( Filter(
        Master,((IntermediateStatus.Value="Submitted" && AttorneyFor.Value="Approved by Manager")||IntermediateStatus.Value="Approved by Supervisor"||IntermediateStatus.Value="Approved by VP") ,
        If(
            IsBlank(Dropdown1_4.Selected.Result),
            true,
            InitatorName.DisplayName = Dropdown1_4.Selected.Result
        ) 
         && If(
            IsBlank(Dropdown1_5.Selected.Result),
            true,
            Group.Value = Dropdown1_5.Selected.Result
        ) 
        ),ID,Descending)
)

sharepoint online – Clear People picker field in Powerapps

I am trying below code to clear people picker field but this does not work when i submit form

On People picker i set defaultselecteditems below so if user select Approve its set value blank in Peoplepicker

Switch(DataCardValue44.Selected.Value,
        "Approve",{Value:Blank()},)

and on Submit button i written below

Patch(
   Master,
    {ID: VarID},
    Form3_1.Updates
);

But it does not clear value for people picker

Custom powerapps form not being used for SharePoint list when on Web Part page

I have a SharePoint site where I have created a list that uses a custom PowerApps form and different Web Part pages that display different views of the list, this setup is to enable me to send out links to the list that will display different information to different users as part of an internal process.

The issue I am having is that when I attempt to view/ edit/ create a list item from one of the Web Part Pages it does not use the custom PowerApps form, despite the custom form being used when I’m accessing the list directly.

I have been looking into this for a while now and can’t seem to find a consistent and reliable fix. I have however noticed that when I click the “Return to classic SharePoint” button from the list, the pages will then use the custom form but only on that browser session and only until I exit classic. I thought then if I set the list experience to “Classic experience” that it may replicate this behavior but this doesn’t seem to resolve the issue.

Any advice provided would be greatly appreciated.

Trying to populate choices in drop down on PowerApps based on SharePoint People Picker field

I have a PowerApps app that connects to a SharePoint list. There is a column, Approver, that I want to use to filter a report. Approver is a People Picker field. I want to have a drop-down input box on my PowerApps screen that has the names of Approvers from the SharePoint list, so that I can filter the results based on approvers rather than typing in a name from the GAL. Is this possible, and if so, any tips on how to do this?

sharepoint online – Delegation warning in PowerApps for SortByColumns

In order to avoid the delegation limitation you want to avoid filtering SharePoint lists directly. Instead, you can simply query a variable that contains your entire list in memory.

The only tricky part here is to get the entire SharePoint list first. In order to do it, you want to get the list items in chunks of 200-or-so items. Consider this example:

// loading all meetings to memory:
ClearCollect(InMemoryMeetings,
  Filter('Meetings', ID > 0,  ID <= 200),
  Filter('Meetings', ID > 200, ID <= 400), 
  Filter('Meetings', ID > 400, ID <= 600), 
  Filter('Meetings', ID > 600, ID <= 800),
  Filter('Meetings', ID > 800, ID <= 1000),
  Filter('Meetings', ID > 1000, ID <= 1200),
  Filter('Meetings', ID > 1200, ID <= 1400),
  Filter('Meetings', ID > 1400, ID <= 1600),
  Filter('Meetings', ID > 1600, ID <= 1800),
  Filter('Meetings', ID > 1800, ID <= 2000),
  Filter('Meetings', ID > 2000, ID <= 2200),
  Filter('Meetings', ID > 2200, ID <= 2400),
  Filter('Meetings', ID > 2400, ID <= 2600),
  Filter('Meetings', ID > 2600, ID <= 2800),
  Filter('Meetings', ID > 2800, ID <= 3000),
  Filter('Meetings', ID > 3000, ID <= 3200)
);

Then you can filter against this variable instead. Even using complex quieries like these:

Filter(
    InMemoryMeetings,
    Or(
        StartsWith(TextSearch.Text, Text('Meeting Number')),
        TextSearch.Text in Text('Start Date', "($-en-US)yyyy-mm-dd"),
        TextSearch.Text in Text('End Date', "($-en-US)yyyy-mm-dd"),
        ID exactin Filter(InMemoryMotions, TextSearch.Text in 'Motion Text').MeetingID, 
        And(
            ID exactin Filter(InMemoryMotions, FirstWord in 'Motion Text').MeetingID,
            ID exactin Filter(InMemoryMotions, SecondWord in 'Motion Text').MeetingID  
        ),
        And(
            ID exactin Filter(InMemoryMotions, FirstWord in Keywords).MeetingID,
            ID exactin Filter(InMemoryMotions, SecondWord in Keywords).MeetingID  
        )
    )
)

How to handle GroupUserAdding event in power automate or powerapps

We are migrating Sharepoint farm solution to SP Online.

In solution we have GroupUserAdding receiver. In event receiver, i need to validate user first with some condition before adding to group.  I am not able to find any GroupUserAdding regarding trigger in power automate or in powerapps.

Please help any feasibility or workaround to achieve this.

document library – Filtering lookup values based on another column powerapps

I have a document library (with document sets). And while I wanted to use enterprise metatags (so I can use nested tags) the users feel that this is too much of a confusion and would like to have two columns where the second would be filtered based on the first. I thought of using powerapps and followed plenty of examples like this one https://www.portiva.nl/portiblog/2018/11/09/creating-conditional-lookup-columns-in-sharepoint-with-powerapps
but it seems like an overkill to have two sharepoint lists while I could have one.
I found this topic: Filtering lookup values based on another column in another list, sharepoint online and powerapps but I can’t decypher what is the logic behind the solution.
and if I just try to copy and paste (replacing names) I get constantly errors.

In my scenario, I have a sharepoint list called “Project Tags” with two columns. One is Document Category and the second Document Type with a 1:N relation.
Then I have the doc library where I thought of using a drop-down to represent the document categories and a lookup for the document type.

Now what I look to do is to filter the document type, based on the value of the document category. If needed, I can replace the drop-down with a lookup.

Anyone kind enough to help me out with this?