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 / Update SharePoint List...
Power Apps
Unanswered

Update SharePoint List column with TEXT based on Power App Buttons

(0) ShareShare
ReportReport
Posted on by 22

I have spent 2 days ready forums on this site related to this issue and none of them have been able to help do what i'm trying to do. I'm sure its me. but...

 

I have a large Sharepoint list that has users and applications they have installed among other fields. So far, I have a Power app, that, when a user opens it, onstart filters on their email. So they can only see their apps. So first screen looks like below:

1.PNG

 

 

 

 

 

 

 

 

 

When a user clicks the chevron, it takes them to an edit page like below. This is where I am having issues. My goal is for the user to click yes, or no, then have the text 'Yes' or 'No' populate the associated column. So in the example below: there is a row in the list with the users email: f.l@company.com, App: Adobe Acrobat, Do you need the app? (single line text), etc.

 

2.PNG

 

 

 

 

 

 

 

 

 

 

From the research I've done on this site, I know Patching is involved. But none of the solutions I have tried have worked for me. The SP list never updates. I've tried changing the column to single line text, so it can enter the string, but to no avail. Changed to choice (y/n) column and tried boolean patch method, same result. I would share code examples of what I have, but I have tried so many different methods, I wouldnt know which one to provide. None worked for me.

 

Any assistance with code/images would be greatly appreciated!

Categories:
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @lier_bag20 

    The difficulty you are experiencing is that you are trying to design a Many-to-Many relationship. with a single table.  One user can have many software programs and each program can have many users.  To properly model your app, Three lists would be involved. !!.jpg

    Once you have the back end structure properly designed, It would be straightforward to build the app.   ld have a dropdown with the user and a gallery to show the software for that user.   Likewise, you could have a dropdown for the software and show the users who are associated with it.  For a more complete understanding of how to design the lists for maximum flexibility, see my blog post here   https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Database-Design-Fundamentals-and-PowerApps-An-Overview/ba-p/184485 

     

     

  • lier_bag20 Profile Picture
    22 on at

    Thanks for the reply @Drrickryp . Few questions, Does the fact that the app is filtered on one email effect anything patching wise? For ex, in my screens, the app automatically filters on the logged in users email, so apps shown are assigned to one person. So shouldn't the app only patch the items that are filtered? Or is it not that simple?

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @lier_bag20 

    Filtering has no effect on the patch as it patches the datasource. Filtering allows the user to visualize part of the datasource and work with that part. 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 397 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 354

#3
WarrenBelz Profile Picture

WarrenBelz 232 Most Valuable Professional

Last 30 days Overall leaderboard