web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Sharepoint List , I ne...

Power Apps

Answered

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

(0) Share

Report

Report

Posted on by JD_26

102

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:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

theapurva 970 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
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'.
JD_26 102 on at

Like
a
(0)

Report
Copy link

Link copied!

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));

Join the conversation