cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Amsha5
Helper II
Helper II

set a column value on sharepoint list to default with a button on power apps

Hello There, 

Is there any way to set a column value on sharepoint list to default with a button on power apps ? 

the column changes between 1 to 7 and i need a reset button to send the values on the column to 1 !!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
JR-BejeweledOne
Super User
Super User

You can do it like this:   If your clickCount column is text, please wrap the 1 in quotes "1"

 

UpdateIf(SharePointList, clickCount <> 1, {clickCount: 1})

   



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

View solution in original post

10 REPLIES 10
Nogueira1306
Super User
Super User

Hey! Explain your question better....

You want to set a default on a SP List?

JR-BejeweledOne
Super User
Super User

I am going to presume that you are already working with this SharePoint list in your power app.   Your question reads like you want to set all the values in that column back to 1 at the same time,  would this be correct?



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.
PG_WorXz10
Resident Rockstar
Resident Rockstar

Hi @Amsha5 ,

 

If you want to send the value from PowerApps to SharePoint list column value than its possible but if you want to change default value of the sharepoint list from PowerApps its not possible. 

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.

@Nogueira1306 

I have a column on SPO. What i need is a reset button on my power app that sends the values on the column to 1 whenever i press the button !!

22.PNG

I understood that part.   Are you wanting to reset the value for all items in the SharePoint list or for a single item when you press the button?



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

@JR-BejeweledOne I need it for all items on the column 

@PG_WorXz10  Yes i want to send the value from power apps to share point list 🙂

JR-BejeweledOne
Super User
Super User

You can do it like this:   If your clickCount column is text, please wrap the 1 in quotes "1"

 

UpdateIf(SharePointList, clickCount <> 1, {clickCount: 1})

   



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.
PG_WorXz10
Resident Rockstar
Resident Rockstar

Hi @Amsha5 ,

 

Please use the below code if it helps. 

 

on button select: Set(varDefaultValue,true);Set(varValue,1);

On Patch clickCount: if(varDefaultValue,varValue,YourNormalValue);

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,038)