I'm struggling with the following.
I want to disable an icon when the record has been saved into a SQL database.
I've tried many ways and the closest I've reached is that it disables all the icons in the gallery, but I only want the icon disabled when the matching record is already saved in the SQL database.
Any ideas how to achieve this?
In the attacments you will find some screenshots to make it a bit more clearer.
Proud to be a Flownaut!
Go to Solution.
After a long time searching and trying out alot of different things I've found the solution to my problem.
The solution was pretty simple afterwards.
But this is what I did on the DisplayMode of my Icon:
If(Body1_1.Text in First(Search('[dbo].[Jobresults]',Body1_1.Text,"F_PPN_ID")).F_PPN_ID, DisplayMode.Disabled,DisplayMode.Edit)
So I didn't have to check whether it was empty or not, I just had to check with the in whether a field on my gallery (Body1_1.Text) was equal to a field (F_PPN_ID) in my database.
Hope this helps other people too.
View solution in original post
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand