cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nida_Sayedi
Frequent Visitor

Power apps lookup column filters

I have a list sharepoint list as "ProjectList" with column Project that has project name

Nida_Sayedi_1-1657013710328.png

 

another list "Stages" that has column Title which has 5 stages names

Nida_Sayedi_0-1657013670207.png

I have another list called request list where i have Title column,2 lookup colums Projectname(lookup from projectlist) and Projectstage (lookup from Stage list)

 

How do i filter if i have same project with 2 stages completed , the stage column should display remaining 3 stages only for a particular project, 

when a new row is added in request list based on project name , stage dropdown shoud display only stages excluding already submitted one ,shoud display only remaining stages

 

Example : if we already submitted Project 3 and Product Proposal ,so next time if we try to Select Product Proposal for Project 3 it should disable that selection with some notification and allow remaining ones to select

 

Nida_Sayedi_2-1657014336316.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Nida_Sayedi,

Just ty the solution and tell me if this could work for you.

No, I don't mean that.

 

Just set the proj stage Combo Box items property as the above formula.

Best Regards,
Qi

View solution in original post

4 REPLIES 4
v-qiaqi-msft
Community Support
Community Support

Hi @Nida_Sayedi,

Do you want to exclude project stages from the dropdown if there is finished stages for the same project name?

Could you please share a bit more about your scenario?

 

To be easier to achieve your need, I suggest to connect to both ProjectList and Stage list your app.

Set the Proj Stage Combo Box Items property as below:

 

 

Filter(
    Choices(Request.'proj Stage'),
    !(Value in ForAll(
        Filter(
            Request,
            proj.Value = DataCardValue5.Selected.Value
        ).'proj Stage',
        'proj Stage'.Value
    ))
)

 

 

Best Regards,
Qi
Nida_Sayedi
Frequent Visitor

@v-qiaqi-msft 

yeah I need my stage dropdown to display only the stages which have not been submitted before

Do u mean to say I should add a lookup column proj Stage (from stage list) in project list?

Hi @Nida_Sayedi,

Just ty the solution and tell me if this could work for you.

No, I don't mean that.

 

Just set the proj stage Combo Box items property as the above formula.

Best Regards,
Qi
Nida_Sayedi
Frequent Visitor

I have a flow which submits attachment/documents  from powerapp to sharepoint list and sends it for approval in outlook mail 

If I am attaching 6 documents I am getting only 5 documents in the email for approval, y is it so ?

the size of all the files altogether is (less then 8 MB) 

from power app side its taking all 6 files but  I am able to receive only 5 files in mail for approval ?

how do I look into this ?

 

 
 
 

 

 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (4,353)