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

one of the column details should disappear in an item when the user clicks on the button

Hi

 

I have created a list with 7 columns and in all items view I'm displaying all the columns. There is a column called Site Admin (Person or Groups Field)  I'm displaying all the Site Admin in the list for all the items through pro-grammatically and also have Verified Column (Check box Field) When the user clicks on the edit item it will take to the Power Apps customized form.

 

In the form I'm not showing the Site Admin and  Verified Columns.

So here is the tricky part I'm facing.

 

  1. I have a button called "Remove Site Admin" When user clicks on the button their name should disappear from the  Site Admin column in an item 
  2. I also have a button called “confirm Account” when ever the user clicks on that button it should automatically need to update the Verified Column to "Yes"
 
 

I would really appreciate your help thanks in advance.

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
mdevaney
Super User
Super User

@shaikbashu786

#1 OnSelect property of Remove Site Admin button

Patch(
your_datasource_name,
SharepointIntegration.Selected,
{‘Site Admin’: Blank()}
)

#2 OnSelect property of Verified button.

Patch(
your_datasource_name,
SharepointIntegration.Selected,
{Verified: true}
)

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

View solution in original post

v-xida-msft
Community Support
Community Support

Hi @shaikbashu786 ,

Could you please share a bit more about your scenario?

Do you want to remove yourself from the "Site Admin" column in an item when you press the "Remove Site Admin" button?

Further, have you enabled "Allow multiple selections" option for "Site Admin" column in your SP List?

 

I have made a test on my side, please consider take a try with the following workaround:

Firstly, please turn on the "Formula-level error management" option within Advanced settings of App settings of your app.

1. If you have enabled "Allow multiple selections" option for "Site Admin" column in your SP List:

Set the OnSelect property of the "Remove Site Admin" button to following:

Set(ExistingUsers, SharePointIntegration.Selected.'Site Admin');
Patch(
    'Your SP List',
    SharePointIntegration.Selected,
    {
        'Site Admin': Blank()
    }
);
Patch(
    'Your SP List',
    SharePointIntegration.Selected,
    {
        'Site Admin': Filter(ExistingUsers, Email <> User().Email)
    }
)

 

2. If you do not enable "Allow multiple selections" option for "Site Admin" column in your SP List (clear the "Site Admin" column):

If(
   SharePointIntegration.Selected.'Site Admin'.Email = User().Email,
   Patch(
         'Your SP List',
          SharePointIntegration.Selected,
         {
          'Site Admin': Blank()
         }
   )
)

Note: The 2nd condition is used to clear 'Site Admin' column value if the 'Site Admin' column value is current login user.

 

Please consider take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
mdevaney
Super User
Super User

@shaikbashu786

#1 OnSelect property of Remove Site Admin button

Patch(
your_datasource_name,
SharepointIntegration.Selected,
{‘Site Admin’: Blank()}
)

#2 OnSelect property of Verified button.

Patch(
your_datasource_name,
SharepointIntegration.Selected,
{Verified: true}
)

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

Thanks for the solution.

 

#1 Button for "Site Admin" is not working as expected, but the second one is working as expected.

 

In there any other solution for  #1 "Site Admin Button"?

 

Thanks in Advance

v-xida-msft
Community Support
Community Support

Hi @shaikbashu786 ,

Could you please share a bit more about your scenario?

Do you want to remove yourself from the "Site Admin" column in an item when you press the "Remove Site Admin" button?

Further, have you enabled "Allow multiple selections" option for "Site Admin" column in your SP List?

 

I have made a test on my side, please consider take a try with the following workaround:

Firstly, please turn on the "Formula-level error management" option within Advanced settings of App settings of your app.

1. If you have enabled "Allow multiple selections" option for "Site Admin" column in your SP List:

Set the OnSelect property of the "Remove Site Admin" button to following:

Set(ExistingUsers, SharePointIntegration.Selected.'Site Admin');
Patch(
    'Your SP List',
    SharePointIntegration.Selected,
    {
        'Site Admin': Blank()
    }
);
Patch(
    'Your SP List',
    SharePointIntegration.Selected,
    {
        'Site Admin': Filter(ExistingUsers, Email <> User().Email)
    }
)

 

2. If you do not enable "Allow multiple selections" option for "Site Admin" column in your SP List (clear the "Site Admin" column):

If(
   SharePointIntegration.Selected.'Site Admin'.Email = User().Email,
   Patch(
         'Your SP List',
          SharePointIntegration.Selected,
         {
          'Site Admin': Blank()
         }
   )
)

Note: The 2nd condition is used to clear 'Site Admin' column value if the 'Site Admin' column value is current login user.

 

Please consider take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-xida-msft 

I have tested this code but it does not appear to work.  This is likely because 'Site Admin' is a Person field.  Do you know how to clear that field without using MS Automate?

 

If(
   SharePointIntegration.Selected.'Site Admin'.Email = User().Email,
   Patch(
         'Your SP List',
          SharePointIntegration.Selected,
         {
          'Site Admin': Blank()
         }
   )
)

 

@shaikbashu786 

Which solution from @v-xida-msft worked for you?  I couldn't get it to work for Site Admin.

Hi @v-xida-msft ,

 

I tested it and worked, now i would able to remove myself with the button click 🙂 

 

Thanks a lot with the quick turn around on my question.

 

Thanks and have a great week ahead.

Yes, actually in the first message i didn't provide you the proper info. But @v-xida-msft assumed my scenario and provided the formula, but from  my end it worked fine.

 

Thanks to both of you for finding the solution.

@shaikbashu786 

It all makes sense now.  Thank you for replying and informing me.

Hi @v-xida-msft  & @mdevaney 

 

Is there a way to remove all the "Site Admins" from the Column with the current logged in user on one button click?

 

I'm Using the first scenario for the solution you provided.

 

Thanks in Advance. 

Helpful resources

Announcements

Celebrating the May Super User of the Month: Laurens Martens

  @LaurensM  is an exceptional contributor to the Power Platform Community. Super Users like Laurens inspire others through their example, encouragement, and active participation. We are excited to celebrated Laurens as our Super User of the Month for May 2024.   Consistent Engagement:  He consistently engages with the community by answering forum questions, sharing insights, and providing solutions. Laurens dedication helps other users find answers and overcome challenges.   Community Expertise: As a Super User, Laurens plays a crucial role in maintaining a knowledge sharing environment. Always ensuring a positive experience for everyone.   Leadership: He shares valuable insights on community growth, engagement, and future trends. Their contributions help shape the Power Platform Community.   Congratulations, Laurens Martens, for your outstanding work! Keep inspiring others and making a difference in the community!   Keep up the fantastic work!        

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Check Out the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community.  We can't wait to see what you "cook" up!      

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Community Roundup: A Look Back at Our Last 10 Tuesday Tips

As we continue to grow and learn together, it's important to reflect on the valuable insights we've shared. For today's #TuesdayTip, we're excited to take a moment to look back at the last 10 tips we've shared in case you missed any or want to revisit them. Thanks for your incredible support for this series--we're so glad it was able to help so many of you navigate your community experience!   Getting Started in the Community An overview of everything you need to know about navigating the community on one page!  Community Links: ○ Power Apps ○ Power Automate  ○ Power Pages  ○ Copilot Studio    Community Ranks and YOU Have you ever wondered how your fellow community members ascend the ranks within our community? We explain everything about ranks and how to achieve points so you can climb up in the rankings! Community Links: ○ Power Apps ○ Power Automate  ○ Power Pages  ○ Copilot Studio    Powering Up Your Community Profile Your Community User Profile is how the Community knows you--so it's essential that it works the way you need it to! From changing your username to updating contact information, this Knowledge Base Article is your best resource for powering up your profile. Community Links: ○ Power Apps ○ Power Automate  ○ Power Pages  ○ Copilot Studio    Community Blogs--A Great Place to Start There's so much you'll discover in the Community Blogs, and we hope you'll check them out today!  Community Links: ○ Power Apps ○ Power Automate  ○ Power Pages  ○ Copilot Studio    Unlocking Community Achievements and Earning Badges Across the Communities, you'll see badges on users profile that recognize and reward their engagement and contributions. Check out some details on Community badges--and find out more in the detailed link at the end of the article! Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio    Blogging in the Community Interested in blogging? Everything you need to know on writing blogs in our four communities! Get started blogging across the Power Platform communities today! Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio   Subscriptions & Notifications We don't want you to miss a thing in the community! Read all about how to subscribe to sections of our forums and how to setup your notifications! Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio   Getting Started with Private Messages & Macros Do you want to enhance your communication in the Community and streamline your interactions? One of the best ways to do this is to ensure you are using Private Messaging--and the ever-handy macros that are available to you as a Community member! Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio   Community User Groups Learn everything about being part of, starting, or leading a User Group in the Power Platform Community. Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio   Update Your Community Profile Today! Keep your community profile up to date which is essential for staying connected and engaged with the community. Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio   Thank you for being an integral part of our journey.   Here's to many more Tuesday Tips as we pave the way for a brighter, more connected future! As always, watch the News & Announcements for the next set of tips, coming soon!

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today! https://aka.ms/PowerUp  

Top Solution Authors
Top Kudoed Authors
Users online (4,164)