Sharepoint List , I need to change all values in a column that are F to Future

Like (0) Share

Report

Posted on 14 Oct 2022 09:21:49 by JD_26

101

Hi I am trying to make sure I have the correct formula to change values in a Sharepoint List that feeds my Power App , as if I could not find any other way to update it automatically.

The code I have created is - ForAll(Master_Profiles, If(field_15 ="F",{field_15 : "Future"}

The SharePoint Table is called Master_Profiles , and the the field name field_15 is a text column , which contains multiple codes , that I need to change to their actual name , so in this example

I want to loop through all of the rows and for each row that has an F , change the value to Future.

As this data is live data I wanted to make sure it was correct. As IU have only been learning Power Apps for 3 weeks.

Any help would be much appreciated.

Thankyou

Categories:

General Questions

All responses (2)

Answers (1)

JD_26 101 on 19 Oct 2022 at 12:55:16

Like (0)

Report

Re: Sharepoint List , I need to change all values in a column that are F to Future

Thanks that worked great , my last task is to have a button to delete associated tables by 2 matching values
I have added a delete button to the supplier gallery , which is called supplier_search
Is this code I have created from some research correct . ???
RemoveIf('Contacts',field_2=supplier_search.Selected.Title&&field_13=supplier_search.Selected.field_15));
RemoveIf(Activity_List,field_2=supplier_search.Selected.field_15&&Title=master_search.Selected.Title));
Verified answer

theapurva 965 Super User 2024 Season 1 on 14 Oct 2022 at 11:22:54

Like (0)

Report
Re: Sharepoint List , I need to change all values in a column that are F to Future

Hello @JD_26 ,
Add one button to your app and put OnSelect formula as below:

UpdateIf(Master_Profiles, field_15 ="F",{field_15 : "Future"})

this will replace all items with 'Future'.