Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Building Power Apps / Power Apps Formula
Power Apps - Building Power Apps
Unanswered

Power Apps Formula

(0) ShareShare
ReportReport
Posted on by Nayana_MS 137

Hi 

 

If(
    Dropdown1.Selected.Value = "--Select--" || Dropdown2.Selected.Value = "--Select--" || Dropdown5.Selected.Value = "--Select--" || IsBlank(DataCardValue2.Text) || IsBlank(DataCardValue4.Text) || IsBlank(ComboBox1.Selected) || IsBlank(ComboBox1_1.Selected) || IsBlank(ComboBox2_5.Selected) || IsBlank(ComboBox1.Selected.DisplayName) || DatePicker2.SelectedDate < Today() || DatePicker1.SelectedDate < Today(),
    Notify(
        "Please fill the form and ensure the selected date is not in the past",
        NotificationType.Warning
    ),
    If(
        !IsBlank(
            LookUp(
                ResourceAllocation_AvailableResources,
                Resources = ComboBox1.Selected.DisplayName
            ).'Project1 Name'
        ) && !IsBlank(
            LookUp(
                ResourceAllocation_AvailableResources,
                Resources = ComboBox1.Selected.DisplayName
            ).'Project2 Name'
        ),
        Notify(
            "Resource " & ComboBox1.Selected.DisplayName & " is allocated to both projects.",
            NotificationType.Warning
        ),
       
        If(
                            IsBlank(
                                LookUp(
                                    ResourceAllocation_AvailableResources,
                                    (Resources = ComboBox1.Selected.DisplayName || Resources = ComboBox2.Selected.DisplayName || Resources = ComboBox3.Selected.DisplayName || Resources = ComboBox4.Selected.DisplayName || Resources = ComboBox5.Selected.DisplayName)
                                ).'Project1 Name'
                            ),
                            UpdateIf(
                                ResourceAllocation_AvailableResources,
                                (Resources = ComboBox1.Selected.DisplayName || Resources = ComboBox2.Selected.DisplayName || Resources = ComboBox3.Selected.DisplayName || Resources = ComboBox4.Selected.DisplayName || Resources = ComboBox5.Selected.DisplayName),
                                {
                                    Allocation1: PowerPlatformLabel.Text,
                                    'Total Engagements this month': If(
                                        'Total Engagements this month' = "2",
                                        "2",
                                        "1"
                                    ),
                                    'Project1 Name': ProjectNameLabel.Text,
                                    'P1 Start Date': StartDateLabel.Text,
                                    'P1 End Date': EndDateLabel.Text,
                                    Project1UniqueId: DataCardValue12.Text,
                                    'Project1 Category': Dropdown1.SelectedText.Value,
                                    'TL1 MailId': DataCardValue26.Text,
                                    'P1 Reporting Manager': ComboBox2_5.Selected.DisplayName
                                }
                            );
                            ResourceAllocationMail.Run(
                                If(
                                    !IsBlank(ComboBox1.Selected.Mail),
                                    ComboBox1.Selected.Mail,
                                    ""
                                ) & If(
                                    !IsBlank(ComboBox2.Selected.Mail),
                                    ", " & ComboBox2.Selected.Mail,
                                    ""
                                ) & If(
                                    !IsBlank(ComboBox3.Selected.Mail),
                                    ", " & ComboBox3.Selected.Mail,
                                    ""
                                ) & If(
                                    !IsBlank(ComboBox4.Selected.Mail),
                                    ", " & ComboBox4.Selected.Mail,
                                    ""
                                ) & If(
                                    !IsBlank(ComboBox5.Selected.Mail),
                                    ", " & ComboBox5.Selected.Mail,
                                    ""
                                ),
                                DataCardValue2.Text,
                                ComboBox2_5.Selected.DisplayName
                            );
                            SubmitForm(Form1),
                            If(
                                IsBlank(
                                    LookUp(
                                        ResourceAllocation_AvailableResources,
                                        (Resources = ComboBox1.Selected.DisplayName || Resources = ComboBox2.Selected.DisplayName || Resources = ComboBox3.Selected.DisplayName || Resources = ComboBox4.Selected.DisplayName || Resources = ComboBox5.Selected.DisplayName)
                                    ).'Project2 Name'
                                ),
                                UpdateIf(
                                    ResourceAllocation_AvailableResources,
                                    (Resources = ComboBox1.Selected.DisplayName || Resources = ComboBox2.Selected.DisplayName || Resources = ComboBox3.Selected.DisplayName || Resources = ComboBox4.Selected.DisplayName || Resources = ComboBox5.Selected.DisplayName),
                                    {
                                        Allocation2: PowerPlatformLabel.Text,
                                        'Total Engagements this month': If(
                                            'Total Engagements this month' = "2",
                                            "2",
                                            "1"
                                        ),
                                        'Project2 Name': ProjectNameLabel.Text,
                                        'P2 Start Date': StartDateLabel.Text,
                                        'P2 End Date': EndDateLabel.Text,
                                        Project2UniqueId: DataCardValue12.Text,
                                        'Project2 Category': Dropdown1.SelectedText.Value,
                                        'TL2 MailId': DataCardValue26.Text,
                                        'P2Reporting Manager': ComboBox2_5.Selected.DisplayName
                                    }
                                );
                                ResourceAllocationMail.Run(
                                    If(
                                        !IsBlank(ComboBox1.Selected.Mail),
                                        ComboBox1.Selected.Mail,
                                        ""
                                    ) & If(
                                        !IsBlank(ComboBox2.Selected.Mail),
                                        ", " & ComboBox2.Selected.Mail,
                                        ""
                                    ) & If(
                                        !IsBlank(ComboBox3.Selected.Mail),
                                        ", " & ComboBox3.Selected.Mail,
                                        ""
                                    ) & If(
                                        !IsBlank(ComboBox4.Selected.Mail),
                                        ", " & ComboBox4.Selected.Mail,
                                        ""
                                    ) & If(
                                        !IsBlank(ComboBox5.Selected.Mail),
                                        ", " & ComboBox5.Selected.Mail,
                                        ""
                                    ),
                                    DataCardValue2.Text,
                                    ComboBox2_5.Selected.DisplayName
                                );
                                SubmitForm(Form1)
                            )
                        )
                    )
                )
       Im using this above formula in power apps ,Im having issue with updateif , whenever i fill the form with resource1(ex:xyz) the the details will be stored in project1 and second time if i fill the form with resource1(ex:xyz) and resource2(ex:abc),what is happening is for resource1(ex:xyz) it goes and store in project2 but for resource2(ex:abc) also it stores in project2,i dont want this to happen ,i want for resource1(ex:xyz) it has to store in project2 and for resource2(ex:abc) it has to store in project1
 
Thank You
Screenshot 2024-05-21 102730.png
  • Nayana_MS Profile Picture
    Nayana_MS 137 on at
    Re: Power Apps Formula

    @mmbr1606 

    now I'm getting different type of error saying invalid number of arguments  received 3 ,expected 2

  • mmbr1606 Profile Picture
    mmbr1606 13,171 Super User 2025 Season 1 on at
    Re: Power Apps Formula

    hey @Nayana_MS 

     

    another shot:

    If(
 Dropdown1.Selected.Value = "--Select--" || Dropdown2.Selected.Value = "--Select--" || Dropdown5.Selected.Value = "--Select--" || IsBlank(DataCardValue2.Text) || IsBlank(DataCardValue4.Text) || IsBlank(ComboBox1.Selected) || IsBlank(ComboBox1_1.Selected) || IsBlank(ComboBox2_5.Selected) || IsBlank(ComboBox1.Selected.DisplayName) || DatePicker2.SelectedDate < Today() || DatePicker1.SelectedDate < Today(),
 Notify(
 "Please fill the form and ensure the selected date is not in the past",
 NotificationType.Warning
 ),
 If(
 !IsBlank(
 LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName
 ).'Project1 Name'
 ) && !IsBlank(
 LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName
 ).'Project2 Name'
 ),
 Notify(
 "Resource " & ComboBox1.Selected.DisplayName & " is allocated to both projects.",
 NotificationType.Warning
 ),
 
 With(
 {
 resource1Project1: LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName
 ).'Project1 Name',
 resource1Project2: LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName
 ).'Project2 Name'
 },
 If(
 IsBlank(resource1Project1),
 UpdateIf(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName,
 {
 Allocation1: PowerPlatformLabel.Text,
 'Total Engagements this month': If(
 'Total Engagements this month' = "2",
 "2",
 "1"
 ),
 'Project1 Name': ProjectNameLabel.Text,
 'P1 Start Date': StartDateLabel.Text,
 'P1 End Date': EndDateLabel.Text,
 Project1UniqueId: DataCardValue12.Text,
 'Project1 Category': Dropdown1.SelectedText.Value,
 'TL1 MailId': DataCardValue26.Text,
 'P1 Reporting Manager': ComboBox2_5.Selected.DisplayName
 }
 )
 ),
 If(
 IsBlank(resource1Project2),
 UpdateIf(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName,
 {
 Allocation2: PowerPlatformLabel.Text,
 'Total Engagements this month': If(
 'Total Engagements this month' = "2",
 "2",
 "1"
 ),
 'Project2 Name': ProjectNameLabel.Text,
 'P2 Start Date': StartDateLabel.Text,
 'P2 End Date': EndDateLabel.Text,
 Project2UniqueId: DataCardValue12.Text,
 'Project2 Category': Dropdown1.SelectedText.Value,
 'TL2 MailId': DataCardValue26.Text,
 'P2Reporting Manager': ComboBox2_5.Selected.DisplayName
 }
 )
 )
 ),
 
 With(
 {
 resource2Project1: LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox2.Selected.DisplayName
 ).'Project1 Name',
 resource2Project2: LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox2.Selected.DisplayName
 ).'Project2 Name'
 },
 If(
 IsBlank(resource2Project1),
 UpdateIf(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox2.Selected.DisplayName,
 {
 Allocation1: PowerPlatformLabel.Text,
 'Total Engagements this month': If(
 'Total Engagements this month' = "2",
 "2",
 "1"
 ),
 'Project1 Name': ProjectNameLabel.Text,
 'P1 Start Date': StartDateLabel.Text,
 'P1 End Date': EndDateLabel.Text,
 Project1UniqueId: DataCardValue12.Text,
 'Project1 Category': Dropdown1.SelectedText.Value,
 'TL1 MailId': DataCardValue26.Text,
 'P1 Reporting Manager': ComboBox2_5.Selected.DisplayName
 }
 )
 ),
 If(
 IsBlank(resource2Project2),
 UpdateIf(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox2.Selected.DisplayName,
 {
 Allocation2: PowerPlatformLabel.Text,
 'Total Engagements this month': If(
 'Total Engagements this month' = "2",
 "2",
 "1"
 ),
 'Project2 Name': ProjectNameLabel.Text,
 'P2 Start Date': StartDateLabel.Text,
 'P2 End Date': EndDateLabel.Text,
 Project2UniqueId: DataCardValue12.Text,
 'Project2 Category': Dropdown1.SelectedText.Value,
 'TL2 MailId': DataCardValue26.Text,
 'P2Reporting Manager': ComboBox2_5.Selected.DisplayName
 }
 )
 )
 ),
 
 ResourceAllocationMail.Run(
 If(
 !IsBlank(ComboBox1.Selected.Mail),
 ComboBox1.Selected.Mail,
 ""
 ) & If(
 !IsBlank(ComboBox2.Selected.Mail),
 ", " & ComboBox2.Selected.Mail,
 ""
 ) & If(
 !IsBlank(ComboBox3.Selected.Mail),
 ", " & ComboBox3.Selected.Mail,
 ""
 ) & If(
 !IsBlank(ComboBox4.Selected.Mail),
 ", " & ComboBox4.Selected.Mail,
 ""
 ) & If(
 !IsBlank(ComboBox5.Selected.Mail),
 ", " & ComboBox5.Selected.Mail,
 ""
 ),
 DataCardValue2.Text,
 ComboBox2_5.Selected.DisplayName
 );
 SubmitForm(Form1)
 )
)

     

    Let me know if my answer helped solving your issue.

    If it did please accept as solution and give it a thumbs up so we can help others in the community.



    Greetings

  • Nayana_MS Profile Picture
    Nayana_MS 137 on at
    Re: Power Apps Formula

    @mmbr1606 

    I'm getting same error for the above formula as well

     

     

  • mmbr1606 Profile Picture
    mmbr1606 13,171 Super User 2025 Season 1 on at
    Re: Power Apps Formula

    can u try this modification:

    If(
 Dropdown1.Selected.Value = "--Select--" || Dropdown2.Selected.Value = "--Select--" || Dropdown5.Selected.Value = "--Select--" || IsBlank(DataCardValue2.Text) || IsBlank(DataCardValue4.Text) || IsBlank(ComboBox1.Selected) || IsBlank(ComboBox1_1.Selected) || IsBlank(ComboBox2_5.Selected) || IsBlank(ComboBox1.Selected.DisplayName) || DatePicker2.SelectedDate < Today() || DatePicker1.SelectedDate < Today(),
 Notify(
 "Please fill the form and ensure the selected date is not in the past",
 NotificationType.Warning
 ),
 If(
 !IsBlank(
 LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName
 ).'Project1 Name'
 ) && !IsBlank(
 LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName
 ).'Project2 Name'
 ),
 Notify(
 "Resource " & ComboBox1.Selected.DisplayName & " is allocated to both projects.",
 NotificationType.Warning
 ),
 
 If(
 IsBlank(
 LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName
 ).'Project1 Name'
 ),
 UpdateIf(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName,
 {
 Allocation1: PowerPlatformLabel.Text,
 'Total Engagements this month': If(
 'Total Engagements this month' = "2",
 "2",
 "1"
 ),
 'Project1 Name': ProjectNameLabel.Text,
 'P1 Start Date': StartDateLabel.Text,
 'P1 End Date': EndDateLabel.Text,
 Project1UniqueId: DataCardValue12.Text,
 'Project1 Category': Dropdown1.SelectedText.Value,
 'TL1 MailId': DataCardValue26.Text,
 'P1 Reporting Manager': ComboBox2_5.Selected.DisplayName
 }
 )
 ),
 If(
 IsBlank(
 LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName
 ).'Project2 Name'
 ),
 UpdateIf(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName,
 {
 Allocation2: PowerPlatformLabel.Text,
 'Total Engagements this month': If(
 'Total Engagements this month' = "2",
 "2",
 "1"
 ),
 'Project2 Name': ProjectNameLabel.Text,
 'P2 Start Date': StartDateLabel.Text,
 'P2 End Date': EndDateLabel.Text,
 Project2UniqueId: DataCardValue12.Text,
 'Project2 Category': Dropdown1.SelectedText.Value,
 'TL2 MailId': DataCardValue26.Text,
 'P2Reporting Manager': ComboBox2_5.Selected.DisplayName
 }
 )
 ),
 
 If(
 IsBlank(
 LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox2.Selected.DisplayName
 ).'Project1 Name'
 ),
 UpdateIf(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox2.Selected.DisplayName,
 {
 Allocation1: PowerPlatformLabel.Text,
 'Total Engagements this month': If(
 'Total Engagements this month' = "2",
 "2",
 "1"
 ),
 'Project1 Name': ProjectNameLabel.Text,
 'P1 Start Date': StartDateLabel.Text,
 'P1 End Date': EndDateLabel.Text,
 Project1UniqueId: DataCardValue12.Text,
 'Project1 Category': Dropdown1.SelectedText.Value,
 'TL1 MailId': DataCardValue26.Text,
 'P1 Reporting Manager': ComboBox2_5.Selected.DisplayName
 }
 )
 ),
 If(
 IsBlank(
 LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox2.Selected.DisplayName
 ).'Project2 Name'
 ),
 UpdateIf(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox2.Selected.DisplayName,
 {
 Allocation2: PowerPlatformLabel.Text,
 'Total Engagements this month': If(
 'Total Engagements this month' = "2",
 "2",
 "1"
 ),
 'Project2 Name': ProjectNameLabel.Text,
 'P2 Start Date': StartDateLabel.Text,
 'P2 End Date': EndDateLabel.Text,
 Project2UniqueId: DataCardValue12.Text,
 'Project2 Category': Dropdown1.SelectedText.Value,
 'TL2 MailId': DataCardValue26.Text,
 'P2Reporting Manager': ComboBox2_5.Selected.DisplayName
 }
 )
 ),
 
 ResourceAllocationMail.Run(
 If(
 !IsBlank(ComboBox1.Selected.Mail),
 ComboBox1.Selected.Mail,
 ""
 ) & If(
 !IsBlank(ComboBox2.Selected.Mail),
 ", " & ComboBox2.Selected.Mail,
 ""
 ) & If(
 !IsBlank(ComboBox3.Selected.Mail),
 ", " & ComboBox3.Selected.Mail,
 ""
 ) & If(
 !IsBlank(ComboBox4.Selected.Mail),
 ", " & ComboBox4.Selected.Mail,
 ""
 ) & If(
 !IsBlank(ComboBox5.Selected.Mail),
 ", " & ComboBox5.Selected.Mail,
 ""
 ),
 DataCardValue2.Text,
 ComboBox2_5.Selected.DisplayName
 );
 SubmitForm(Form1)
 )
)

     

    Let me know if my answer helped solving your issue.

    If it did please accept as solution and give it a thumbs up so we can help others in the community.



    Greetings

  • Nayana_MS Profile Picture
    Nayana_MS 137 on at
    Re: Power Apps Formula

    HI @mmbr1606  Thanks for replying 

     

    I'm getting error at these saying invalid argument type (table).expecting a Boolean value instead

        If(
                IsBlank(
                    LookUp(
                        ResourceAllocation_AvailableResources,
                        Resources = ComboBox1.Selected.DisplayName
                    ).'Project1 Name'
                ),
                UpdateIf(
                    ResourceAllocation_AvailableResources,
                    Resources = ComboBox1.Selected.DisplayName,
                    {
                        Allocation1: PowerPlatformLabel.Text,
                        'Total Engagements this month': If(
                            'Total Engagements this month' = "2",
                            "2",
                            "1"
                        ),
                        'Project1 Name': ProjectNameLabel.Text,
                        'P1 Start Date': StartDateLabel.Text,
                        'P1 End Date': EndDateLabel.Text,
                        Project1UniqueId: DataCardValue12.Text,
                        'Project1 Category': Dropdown1.SelectedText.Value,
                        'TL1 MailId': DataCardValue26.Text,
                        'P1 Reporting Manager': ComboBox2_5.Selected.DisplayName
                    }
                )
            ) saying invalid argument type (table).expecting a Boolean value instead
  • mmbr1606 Profile Picture
    mmbr1606 13,171 Super User 2025 Season 1 on at
    Re: Power Apps Formula

    hey @Nayana_MS 

     

    can you try this please:

    If(
 Dropdown1.Selected.Value = "--Select--" || Dropdown2.Selected.Value = "--Select--" || Dropdown5.Selected.Value = "--Select--" || IsBlank(DataCardValue2.Text) || IsBlank(DataCardValue4.Text) || IsBlank(ComboBox1.Selected) || IsBlank(ComboBox1_1.Selected) || IsBlank(ComboBox2_5.Selected) || IsBlank(ComboBox1.Selected.DisplayName) || DatePicker2.SelectedDate < Today() || DatePicker1.SelectedDate < Today(),
 Notify(
 "Please fill the form and ensure the selected date is not in the past",
 NotificationType.Warning
 ),
 If(
 !IsBlank(
 LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName
 ).'Project1 Name'
 ) && !IsBlank(
 LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName
 ).'Project2 Name'
 ),
 Notify(
 "Resource " & ComboBox1.Selected.DisplayName & " is allocated to both projects.",
 NotificationType.Warning
 ),
 
 If(
 IsBlank(
 LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName
 ).'Project1 Name'
 ),
 UpdateIf(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName,
 {
 Allocation1: PowerPlatformLabel.Text,
 'Total Engagements this month': If(
 'Total Engagements this month' = "2",
 "2",
 "1"
 ),
 'Project1 Name': ProjectNameLabel.Text,
 'P1 Start Date': StartDateLabel.Text,
 'P1 End Date': EndDateLabel.Text,
 Project1UniqueId: DataCardValue12.Text,
 'Project1 Category': Dropdown1.SelectedText.Value,
 'TL1 MailId': DataCardValue26.Text,
 'P1 Reporting Manager': ComboBox2_5.Selected.DisplayName
 }
 )
 ),
 If(
 IsBlank(
 LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName
 ).'Project2 Name'
 ),
 UpdateIf(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox1.Selected.DisplayName,
 {
 Allocation2: PowerPlatformLabel.Text,
 'Total Engagements this month': If(
 'Total Engagements this month' = "2",
 "2",
 "1"
 ),
 'Project2 Name': ProjectNameLabel.Text,
 'P2 Start Date': StartDateLabel.Text,
 'P2 End Date': EndDateLabel.Text,
 Project2UniqueId: DataCardValue12.Text,
 'Project2 Category': Dropdown1.SelectedText.Value,
 'TL2 MailId': DataCardValue26.Text,
 'P2Reporting Manager': ComboBox2_5.Selected.DisplayName
 }
 )
 ),
 
 If(
 IsBlank(
 LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox2.Selected.DisplayName
 ).'Project1 Name'
 ),
 UpdateIf(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox2.Selected.DisplayName,
 {
 Allocation1: PowerPlatformLabel.Text,
 'Total Engagements this month': If(
 'Total Engagements this month' = "2",
 "2",
 "1"
 ),
 'Project1 Name': ProjectNameLabel.Text,
 'P1 Start Date': StartDateLabel.Text,
 'P1 End Date': EndDateLabel.Text,
 Project1UniqueId: DataCardValue12.Text,
 'Project1 Category': Dropdown1.SelectedText.Value,
 'TL1 MailId': DataCardValue26.Text,
 'P1 Reporting Manager': ComboBox2_5.Selected.DisplayName
 }
 )
 ),
 If(
 IsBlank(
 LookUp(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox2.Selected.DisplayName
 ).'Project2 Name'
 ),
 UpdateIf(
 ResourceAllocation_AvailableResources,
 Resources = ComboBox2.Selected.DisplayName,
 {
 Allocation2: PowerPlatformLabel.Text,
 'Total Engagements this month': If(
 'Total Engagements this month' = "2",
 "2",
 "1"
 ),
 'Project2 Name': ProjectNameLabel.Text,
 'P2 Start Date': StartDateLabel.Text,
 'P2 End Date': EndDateLabel.Text,
 Project2UniqueId: DataCardValue12.Text,
 'Project2 Category': Dropdown1.SelectedText.Value,
 'TL2 MailId': DataCardValue26.Text,
 'P2Reporting Manager': ComboBox2_5.Selected.DisplayName
 }
 )
 ),
 
 ResourceAllocationMail.Run(
 If(
 !IsBlank(ComboBox1.Selected.Mail),
 ComboBox1.Selected.Mail,
 ""
 ) & If(
 !IsBlank(ComboBox2.Selected.Mail),
 ", " & ComboBox2.Selected.Mail,
 ""
 ) & If(
 !IsBlank(ComboBox3.Selected.Mail),
 ", " & ComboBox3.Selected.Mail,
 ""
 ) & If(
 !IsBlank(ComboBox4.Selected.Mail),
 ", " & ComboBox4.Selected.Mail,
 ""
 ) & If(
 !IsBlank(ComboBox5.Selected.Mail),
 ", " & ComboBox5.Selected.Mail,
 ""
 ),
 DataCardValue2.Text,
 ComboBox2_5.Selected.DisplayName
 );
 SubmitForm(Form1)
 )
)

     

    Let me know if my answer helped solving your issue.

    If it did please accept as solution and give it a thumbs up so we can help others in the community.



    Greetings

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans