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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / SharePointIntegration ...
Power Apps
Unanswered

SharePointIntegration different forms questions - onboarding / offboarding

(0) ShareShare
ReportReport
Posted on by 247
Hello all,
 
I am working on a SharePoint list for Onboarding and Offboarding of employees.
 
I am using the SharePoint integration form and what I am trying to achieve is:
 
  1. NEW -> dropdown to select “OnBoarding” or “OffBoarding”
  2. Based on the selection of “onboarding” or “offboarding” it takes you to complete different fields

 

Here is what I currently I have (my screens) for SharePoinIntegration:

Screenshot 2020-10-12 135645.png

 

I would like some assistance with the:

 

  1. “OnNew"
  2. “OnCancel”
  3. “OnSave”
  4. “OnEdit”
  5. “OnView”

 

in order to achieve:

  1. "OnNew": as mentioned based on selection "onboarding" or "offboarding" to complete different fields and the form to close
  2. "OnCancel": to just close the form
  3. "OnSave": based on the selection "onboarding" or "ofboarding" to save the completed fields
  4. "OnEdit" if the selected raw is "onboarding" then to edit the "onboarding fields
  5. "OnView" : if the selected raw is "onboarding" then to view the "onboarding fields

 

thank you in advance

 

Categories:
I have the same question (0)
  • FabianAckeret Profile Picture
    975 on at

    @kouliscon 

     

    It's difficult to achieve that on the New button as you just have 1 Power Apps form per list. You could build your own New link to create a new entry in Power Apps and pass along your own parameters (such as your content types). However, with the ootb New button from SharePoint it's quite difficult to do that (hint: SPFx extension could help with that).

    However, to edit existing items it's easy to switch between 2 forms. To do that, follow below instructions:

     

    Step 1

    If you'd like to adjust your New Button in SharePoint, you'd need to create so-called Content Types. There are a lot of videos/blogs on this topic. 

    Simply create one, add it to your list and find out its ID before going to step 2

     

    Step 2

    Go to your FormNewOffboard/FormNewOnboard's Visible property and add the following:

     

     

    // FormNewOffboard
    If(FormNewOffboard.Selected.'Content type'.Id = "<content type id>",true,false)
    
    // FormNewOnboard
    If(FormNewOnboard.Selected.'Content type'.Id = "<content type id>",true,false)

     

     

    This will hide the form based on the button you clicked. Perhaps it would make more sense to simply have ONE EditForm and show/hide fields based on the Content-Type. It would make your app faster, and less difficult to administer. 

     

    And my suggestion would even be to have 2 lists instead. One for onboarding and one for offboarding. This way you could achieve everything you want, without cluttering your Onboarding list with fields only the Offboard list needs. And the other way around...

     

    Let me know what you think.


    Please click Accept as Solution if my post answered your question. Like my answer? Consider giving it a Thumbs Up. Others seeking the same answers will be happy you did.

  • kouliscon Profile Picture
    247 on at

    thank you @FabianAckeret  for your reply.

     

    I did look a bit about the "New Button in SharePoint, you'd need to create so-called Content Types" and it seems challenging...

     

    concerning the forms, I made in past a SharePoing Integration three forms I followed the below instructions: 

     

    https://powerapps.microsoft.com/en-us/blog/separate-custom-forms/

     

    so I was thinking somehow to integrate them..

     

    do you have any good link for what you mention of the "New Button in SharePoint, you'd need to create so-called Content Types?"

     

    thank you

  • FabianAckeret Profile Picture
    975 on at

    Hi @kouliscon 

     

    Sure.

    This link should help you to create a content type and add it to your list. When adding the content type, make sure to select Item as the parent content type.

     

    Kind regards,

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 530

#2
WarrenBelz Profile Picture

WarrenBelz 459 Most Valuable Professional

#3
Haque Profile Picture

Haque 314

Last 30 days Overall leaderboard