how to restrict a text box or a submit button after more than 10 times in power apps

[Jupyter123]

I have a text box called 'question' and a submit button called 'generate answer'

So whenever user types any question, and click generate answer , a answer text box will be displayed below and the answer will be shown

So this process is happening in backend using external API and power automate.

Ok, so whatever question they type, it will be saved in sharepoint list  (under a column field called question)

along with answer also it will be saved in sharepoint list (under a column field called answer)

pls note that :

the question text input is named as TextInput1

and submit button is named as Button1

-------------------------------------------------------------------------------------------------------------------------------------

Now my question is,

how can i make the user type question 10 times  only in a day and if the user reaches more than 10 times, the text button and submit button should be disabled. 

how to write logic code for this?

@RusselThomas @WarrenBelz 

------------------------------------------------------------------------------------------------------------------------------------------

pls note: im authenticating user creds in backend using sharepoint list. 

username is saved in a column called 'user'

[zmansuri · Accepted solution]

App.OnStart

Write a filter code that will filter logged in user's record by today's date Something like this:

Set(varCount,CountRows(Filter(ListName, CreatedBy.Email = User().Email && CreatedDate = Today())));

The above code will filter the list by logged in user and today's date and store the count of record in a variable name varcount. Note: CreatedBy and CreatedDate are default sharepoint columns.

Then on your button or wherever you want just check if the count is 10.

For eg.

Your submit button display mode property:

If(varCount < 10,Edit,Disabled);

[Jupyter123]

hey @zmansuri thanks for the quick response.

'Created by' - Sharepoint column i can see in 'hidden column section' but i cannot see 'CreatedDate' column

---------------------------------------------------------------------------------------------------------------------

Apart from this, there's a problem

CreatedBy- shows my name and not the user's name who logged in

but there is a seperate column called 'user1' which shows the user name who logged in

so can u modify your code in such a way ?

i am not really good at coding.

[zmansuri]

This 2 are the columns. Every sharepoint list have them. If created by column have name of the person who created the entry in powerapps. Are you using any power automate flow?

[Jupyter123]

Hi @zmansuri ,
I use power automate for integrating external API in the backend.

I use sharepoint list for authenticating username and password.

Pls note that i created a variable called varUserRecord for saving the username whenever they login.

Set(varUserRecord, {});

Set(varUserRecord, LookUp(logindatabase, Title=Usernametxt.Text && Password=Passwordtxt.Text));

Patch(SPO_LIST, {Title:varUserRecord.Title, question:TextInput1.Text, } );

So in backend sharepoint list i will be having something like this

'User'                        'question'

user123             question they type

-----------------------------------------------------------

the data type of the column user is 'single line of text' i think string type.

so, how the code will be modified as per this requirement?

[Jupyter123]

@WarrenBelz and @zmansuri 

'Createdby' column shows my name and not the user name who has signed in.

but, im saving the user name in a seperate column called 'user'.

so whoever has logged in to my application, the user name will be displayed in column field called 'user'

I use sharepoint list for authenticating username and password.

Pls note that i created a variable called varUserRecord for saving the username whenever they login.

Set(varUserRecord, {});

Set(varUserRecord, LookUp(logindatabase, Title=Usernametxt.Text && Password=Passwordtxt.Text));

Patch(SPO_LIST, {Title:varUserRecord.Title, question:TextInput1.Text, } );

So in backend sharepoint list i will be having something like this

'User'                        'question'

user123             question they type

-----------------------------------------------------------

the data type of the column user is 'single line of text' i think string type.

so, how the code will be modified as per this requirement?

[Jupyter123]

thanks to @zmansuri for solving the issue that i faced.
he is the best author.
appreciate his patience and hats off to his teaching!!