Hi @mbhatt ,
In your original formula you gave two different data sources, depending on whether or not you are the user:
You (Maulik Bhatt"): 'HH Power App'
Everyone else: SpCollection
Is the collection properly populated? If not, that can explain why other users don't see anything. You can resolve that by either populating the collection correctly, or by using using 'HH Power App' for the other users as well:
Sort(
Filter(
'HH Power App',
User().FullName = "Maulik Bhatt" || ('Created by'.DisplayName = User().FullName && (IsBlank(TextInput6.Text) || ID = Value(TextInput6.Text)))
),
ID,
SortOrder.Descending
)
Ps. In the above I also changed the condition for the ID filtering because it doesn't make sense for a user to be able to filter for other User's records. Now, with TextIput6, they can filter for one specific ID as long as they created it.
