Filter ID based on the link

(2) Share

Report

Posted on by azni

111

The screen in Power Apps will be determined based on the link users receive through Power Automate.

There are two lists, IQA and NC. The NC list will use the ID from IQA, specifically called MasterID, to pull data based on the ID created in IQA.

For example:

1. For Head of Department and Team lead: &id=ID

2. For Auditee: &id3=ID

3. For Efficient: &id1=ID

but I tried to use below code to view items based on the selected ID for the users above, BUT nothing coming out:

Filter(
        'Create NC Report',
        MasterID = Gallery1.Selected.ID)

and, just Efficient user can view, not

varID
varEff
varIDAuditee
varIDAuditor
varIDAcctMngr

If(
    !IsBlank(varEff),
    Filter(
        'Create NC Report',
        MasterID = varEff
    ),
    Filter(
        'Create NC Report',
        MasterID = "loading"
    )
)

then for Account manager's code, are not able to test this part as didn't pass the previous approval yet:

If(
    !IsBlank(varIDAcctMngr),
                If(
                    !IsBlank(varIDAcctMngr),
                    Filter(
                        'Create NC Report',
                        MasterID = varIDAcctMngr && Status.Value = "Approve"
                    ),
                    Filter(
                        'Create NC Report',
                        MasterID = varEff
                    )
                )
            )

Would be lovely if you guys can help me why these users are not be able to view the report based on ID.

Correct, i do have parameter sets for types of users

Categories:

Using Apps Using Formulas

General Questions

All responses (2)

Answers (1)

Verified answer

azni 111 on at

Like (0)

Report
Filter ID based on the link

Hi, I do not know what I did. I compare two screens which actually same data but with different code. Then I am reassessing the code to create a similar one with the first screen. Therefore, below is the answer to my own question. Thanks everyone.

If( !IsBlank(varIDAcctMngr), Filter( 'Create NC Report', MasterID = varIDAcctMngr ), If( !IsBlank(varEff), Filter( 'Create NC Report', MasterID = varEff ), If( !IsBlank(varID), Filter( 'Create NC Report', MasterID = varID ), If( !IsBlank(varIDAuditee), Filter( 'Create NC Report', MasterID = varIDAuditee ), If( !IsBlank(varIDAuditor), Filter( 'Create NC Report', MasterID = varIDAuditor ), Blank() ) ) ) ) )
Suggested answer

DBO_DV 4,536 Super User 2025 Season 1 on at

Like (0)

Report

Filter ID based on the link

Hey Azni,

I think what you need tis the Param function.
Here is a blog that explains how tha param function is used: Power Apps: How to pass parameters in the URL? - Manuel T. Gomes (manueltgomes.com)

let me know if you've got any Additional questions.

If this Answered your question please accept it as solution so others can find it as well.

If it helped in any other way consider liking it so we can keep soppurting eachother.