how to search in gallery and why is the Date not showing?

[bbsin]

Hi I like to ask I had follow Reza's video 

1) Why is the date not picking up from SP list? - SP date is dateandTime

2) what is the syntax for user to search in the box - I include - serach(Sharepontlist, Textfltier. text , Description) - the error is the word Description which is  name in the SP list column but it's not working...  please advise

3) the delete icon - how to set to delete the varFormData when selected record is deleted and will remove the data in SP list too?

Thank you

[v-albai-msft]

Hi @bbsin ,

Please check the answers below:

1. What is the column type of your Date column? Please provide the screenshot of your Date column type.

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below, you can see that my Date column is “Date and time” column type: 

I would suggest you re-add a new connection to your SP list, then check if the issue is solved.

Besides, for a test, check if “ThisItem.Modified” can display well.

2. To search SP list through a box based on Description column, you need to set Items property of your Gallery to below(note that Column names must be enclosed in double quotes😞

Search(Sharepontlist, Textfltier.Text ,"Description")

See my results:

3. For the delete icon, you can use formula like below(remember to replace with your own Gallery name):

Remove(Sharepontlist, Gallery1.Selected)​

Or

Remove(Sharepontlist, ThisItem.Selected)

Then when selected record is deleted in your gallery, this record will also be deleted from your list.

Best Regards,

Allen

[bbsin]

Hi My date is also DateandTime

[bbsin]

Hi Valbai-msft, 

thanks.

I have two icons on the main page, edit pencil and view

how to set 

1) When I click the edit pencils it  brings me to the edit screen and at the end will show the submit button, how to create a popup to tell the user that it's a replace of overwriting the  data if they click the  submit button?  Do I need to create another button 

2) the view icon is brig me the to edit mode.. how set to view only and have a button for edit Should the user need to edit?

Thanks.

[bbsin]

Hi 

I like to check my main screen with this icon to view the data ; I set to view as I don't want the user to edit here.  will bring them to the following screen - 3 screen 

main view

1) How to remove the white box when view? just to show all the data

2) how to have a edit icon on the three screen 1,2, 3,  if the user need to edit info and submit as update - that will alter them a popup before they submit???  Currently it only the home icon to bring them back to home .

[v-albai-msft]

Hi @bbsin,

Sorry for the late reply due to my email issue.

First, I need to confirm if you have solved the issues mentioned in your first reply.

If you have solved, for your other new questions, I would suggest you post them in new threads, it would make others easier to focus on one question in one single thread and it will benefit other community members who stuck with the same question.

If you still have issue, do not hesitate to tell me.

Thanks for your understanding.

Best regards,

Allen

[bbsin]

Hi v-albai-msft,

Yes the first issue is fixed. thanks

Noted will post as new posting for other issues.

Thanks for your help 🙂

[v-albai-msft]

Hi @bbsin ,

Thanks for your understanding.

Since your first issue is resolved, you can mark my reply as a solution. This will benefit other users in this community who meets same issue,  so that they can directly see my solution when search same issue.

Best regards,

Allen

[bbsin]

Thanks Allen.