SharePoint Column

[Stylead]

Hello 

I have inventory SharePoint and I want to do this action I tried to search about it but I didn't find anything.

I want to let my SharePoint do this ( if the status is in-store ) the Asset Owner column should be blank.

the status column is a choice and thanks a lot for your kind assistance 

[v-qiaqi-msft]

Hi @Stylead,

Do you want to update the Person column as blank if the Status column is selected as "in-store"?

Could you please share a bit more about your scenario?

Firstly, you should have a canvas app and generate an app automatically based on the SP list directly. 

Then select the Edit Screen and set the Combo Box DefaultSelectedItems property corresponding to the Person data card as below:

If(DataCardValue9.Selected.Value="In Store(CMHS)",[""],[ThisItem.'Asset Owner'])

[Stylead]

Hi @v-qiaqi-msft 

Yes, this is my scenario if the status column is selected as " In-store" the 'Asset Owner' column must be blank. 

I applied your code in the canvas app but it's not working

[v-qiaqi-msft]

Hi @Stylead,

Could you please check my solution one more time?

I set the DefaultSelectedItems property of the Person column, which is the Combo Box within the Asset Owner data card

[Stylead]

@v-qiaqi-msft I update the formula as you suggested to the right combo box but I'm getting this now

[object Object] and when I submit the form asset ower is still there not removed.

[v-qiaqi-msft · Accepted solution]

Hi @Stylead,

There are details you are missing to share with me.

Do you want to update a single-select Person field with a null value when it has existing user name within?

If so, I am afraid that there is no way to achieve this directly in Power Apps.

If you don't provide a value for the People picker box (a Combo Box control) when you edit a record within the Edit form, PowerApps Edit form would think that you don't make any changes to the People Picker column (Person column), so the old value within the Person column would not be changed.

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

As an workaround, you could set the single-select Person field with allow-multi-select and enable the "Formula-level error management" experimental feature in your app's Advanced settings.

I have tested it and here is the result.

1). Set a variable as below to assign the blank value for the multi-select person field:

Set(
    BlankPeople,
    Table(
        {
            Claims: Blank(),
            DisplayName: Blank(),
            Email: Blank(),
            Department: Blank(),
            Picture: Blank(),
            JobTitle: Blank()
        }
    )
)

2). Set DefaultSelectedItems property of the 'Asset Owner' column 

If(DataCardValue23.Selected.Value="In Store(CMHS)",Blank(),Parent.Default)

3). Set the Update property of the 'Asset Owner' data card as below:

If(IsEmpty(DataCardValue11.SelectedItems),BlankPeople,DataCardValue11.SelectedItems)//DataCardValue11 represents the Asset Owner ComboBox

[Stylead]

@v-qiaqi-msft Good morning dear, 

Step 1 and 2 have no issue with the code but step 3 I'm getting below error.

[v-qiaqi-msft]

Hi @Stylead,

How you set the Items property of the Asset Owner Combo Box?

Make sure that you have done as below:

1). Set the 'Asset Owner' Person field with allow-multi-select

2). Enable the "Formula-level error management" experimental feature in your app's Advanced settings.

3). Set the Asset Owner Combo Box Items property as Choices(List.'Asset Owner')

[Stylead]

Hi @v-qiaqi-msft 

1). Allow multi-select Done.

'Asset Owner' is Microsoft365Users of my organization when I allow multi-select my app started giving me errors on all pages.

2). "Formula-level error management" Enabled.

3). Asset Owner Combo Box Items property Choices([@AnaMlaak].'Asset Owner') Done.

Now when I submit the form with the status as "In Store ( CMHS )", the Asset Owner name remains the same not removed and I got this error below.

[Stylead]

Any help would be greatly appreciated!