Hi @ThomasVDS ,
Could you please share a bit more about the "Current Client" column in your CDS Entity? Is it a LookUp column or a Option Set Type column?
Have you taken a try with the Patch function I provided above?
Further, do you want to clear value within the "Current Client" field in your Edit form?
Actually, it is an known issue with Edit form in PowerApps. Within Edit form, we could not clear value within a LookUp field, Choice field, ... which has already been filled with values.
Please check and see if the following thread would help in your scenario:
https://powerusers.microsoft.com/t5/General-Discussion/Clear-DateField-and-Lookup-Column-value/m-p/136709
If the "Current Client" column is a Option Set type column in your CDS Entity, please consider use the following Patch function to clear the "Current Client" column value:
Patch(
'YourCDSEntity',
BrowseGallery1.Selected,
{
'Current Client': {
Value: Blank()
}
}
)
Or
Patch(
'YourCDSEntity',
BrowseGallery1.Selected,
{
'Current Client': {
Id: -1,
Value: Blank()
}
}
)
If the "Current Client" column is a LookUp type column in your CDS Entity, please modify above formula as below:
Patch(
'YourCDSEntity',
BrowseGallery1.Selected,
{
'Current Client': LookUp(Consultants, Consultants = GUID("")) /* <-- set a blank record to the 'Current Client' field */
}
)
Note: The Consultants represents the Unique Identifier in your Consultants Entity.
Please take a try with above solution, check if the issue is solved.
Best regards,
