web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Power Apps Formula
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
Categories:
Building Power Apps
I have the same question (0)
  • mmbr1606 Profile Picture
    mmbr1606 14,605 Super User 2025 Season 2 on at

    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

  • Nayana_MS Profile Picture
    Nayana_MS 137 on at

    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 14,605 Super User 2025 Season 2 on at

    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

    @mmbr1606 

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

     

     

  • mmbr1606 Profile Picture
    mmbr1606 14,605 Super User 2025 Season 2 on at

    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

    @mmbr1606 

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

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
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
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
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans