Image to base 64

 Set(B64image,

    Substitute(JSON(UploadedImage1.Image , IncludeBinaryData)
               """",""
    )
)

Getting site id

 When upload image using graph library as explained in earlier post we can get site id using below

https://atishubh.sharepoint.com/teams/GlobalOpExAssessment/GlobalOpExDeployment/_api/web/id

Search in Combobox based on Contains not StartWith

 Filter(Choices([@'Trainings Event'].'Training Name'),Self.SearchText in Value)

Remove duplicate from collection based on one column

 ClearCollect(col_conComMas, ForAll(Distinct('Contractor Company Master', field_0), Value));

 ForAll(col_conComMas,Collect(col_conComMas2,First(Filter('Contractor Company Master' , field_0=Value))));

col_conComMas2 is the collection with Duplictate removed

Using filter in a gallery

 Filter(SortByColumns(

    Switch(

        var_SelectedTab,

        1,

        col_inPrepRequests,

        2,

        col_readyRequests,

        3,

        col_activeRequests

    ),

    _sortColumn,

    _sortDirection

) , IsBlank(cmbPlant.Selected.Value) || 'Primary Plant' in cmbPlant.Selected.Value ,

IsBlank(cmbArea.Selected.Value) || 'Primary Area' in cmbArea.Selected.Value,

IsBlank(cmbIssuer.Selected.Value) || 'DuPont work responsible'.DisplayName in cmbIssuer.Selected.Value

)