
Hi All,
I have a 2 dropdowns one is Review status another one is Flag Status in a gallery. When Review status value is selected as Conducted the flag status value will be default set to true and it will patch the value to the Gate tracker SharePoint list which will trigger a flow and compare flag status value. When flag status value will be true mail will be sent and flag status value will be updated as false. But in gallery my flag status is showing as true only even though in SharePoint the column value is false. So If I make any changes to the same row the flag status is comparing the value and again it is patching it as Yes and mail is getting triggered again. To avoid mail getting triggered automatically I added this flag status column.
The dropdown default code is:
If(rstatus.Selected.Value = "Conducted", "Yes", This Item.'Flag Status'.Value)
Any help or suggestion on this would be greatly appreciated.