cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Check whether a record is already present and disable a button in a Gallery

Hey all,

 

 

 

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.

 

Kind regards

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Check whether a record is already present and disable a button in a Gallery

Hey all

 

 

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.

 

Kind regards

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





1 REPLY 1
Super User
Super User

Re: Check whether a record is already present and disable a button in a Gallery

Hey all

 

 

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.

 

Kind regards

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 201 members 5,252 guests
Please welcome our newest community members: