sort by ID

[mbhatt]

Hello Everyone ,

i have filter gallery and i want to see my data when new record create output on my gallery will appear new records on top ,

i mean new ticket on top 

i am using this formula but not working there is no error on formula but seems like not working 

suggest me if any solution 

my DataSource is from splist and view my data by New Record ID which is comes from ID column from list

[mbhatt · Accepted solution]

Hi

@BCBuizer 

Textinput6 is my search engine i mean search text and i make this for search Data by ID .

you may see in screenshot 

[mbhatt · Accepted solution]

Hello 

@BCBuizer 

This textinput6 is for search ID i add this textinput6 for search id number and this is for only maulik bhatt 

user dont want see this searchbar textinput6. so I hide this textinput6 and use case of this text input6 is for only admin mean "maulik bhatt " . hey i just check that is working now user can see their records i just make this textinput6 visible true but problem is that i am unable to search anything but user can search their record . as admin i want to search any ID because there is lot of data so if i want to search specific record i will enter just ID number this last formula work well 

[BCBuizer · Accepted solution]

Hi @mbhatt ,

Thanks for the feedback on the TextInput because that changes the formula a bit:

Sort(
	If(
            User().FullName = "Maulik Bhatt",
            Filter('HH Power App', IsBlank(TextInput6.Text) || ID = Value(TextInput6.Text)),
            Filter('HH Power App', 'Created by'.DisplayName = User().FullName)
        )
    ),
	ID,
	SortOrder.Descending
)

Ps. Can you please unmark some of the 11 posts you marked as solutions? Like this it is harder than it should be for other members of the community to find the actual solution.

[mbhatt · Accepted solution]

hello ,,

@BCBuizer 

sure sir i will unmark or remove 

so other member will not get confused 

thanks sir 

and i ll try this solution 

after 1 hour  my system getting update 

i will let you know 

[mbhatt]

Hello 

@BCBuizer 

what ? if i want to use my sp list instead of user name i have another admin list called 'User ID '

so belong from this can see all records and search. and user can see their only 

i think so there is little bit changes made ??

[BCBuizer]

Hi @mbhatt ,

This topic is closed. Please open a new topic for your new question.