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
Community Champion
Community Champion

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.

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 Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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