Power Platform Community Forum Thread Details

Hello!

So I have a Sharepoint List as my data source, called 'Saginaw' that looks something like this :

The important column is the 'PreferFillcolor'. I have a dropdown (Dropdown1) in Powerapps that I want them to be able to select the fill color for their entries :

Currently, on the "OnChange" I have the following :

Patch(
 Saginaw,
 LookUp(
 Saginaw,
 'Created By'.DisplayName = User().FullName
 ),
 {PreferFillColor: Dropdown1.Selected.Value}
)

This seems to change the color in sharepoint for the first entry, but not all of them. I need them all changed for that specific user, any thoughts?
For the "Save and Close" button I also have this, but I don't know if it's necessary or not at this juncture because of changes :

Set(varShowSettings,false);
With(
 {
 wColor: 
 LookUp(
 Saginaw,
 'Created By'.DisplayName = User().FullName
 ).PreferFillColor
 },
 Set(
 gblColor,
 Switch(
 wColor,
 "Blue",
 Color.Blue,
 "Green",
 Color.Green
 )
 )
)

Let me know if you need any more information, thanks!

Categories:

Building Power Apps