Unanswered

Issue with filter, Sorting and email trigger

(0) Share

Report

Posted on by luaxs4

I have 2 issues which seems to be very miniscule but not able to detect it.

Issue 1 - I have a database which i want to view it as log. It pulls the data however it is only pulling the first 25 records only any new record is not getting added in the view. I have filters and using sortbycolumns to ensure latest one is at the top. If I don't use filters I can see all the record although in ascending order but when filter is applied it gets limited to 25. My data row limit is set to 2000.

code that is use for issue 1. In the items property of gallery

SortByColumns(Filter(QualityData,StartsWith(Title,SearchText.Text)&&((Manager.Email=User().Email)||(Checkbox1.Value= false )||Checkbox1.Value&&Manager.Email=CmbSearchName.Selected.Email),('Review Date'>=DateFrom.SelectedDate&&'Review Date'<=DateTo.SelectedDate)),"ID",Descending)

Issue 2.

I have set up a flow using Power automate where when a user submits the data, it should trigger the email to the intended recipient but the issue is while it triggers the email, it is delivery it from my credentials and not the user who submitted the data.

Please help me fix this issue. Hope i am able explain my situation. Image attached for your reference for issue 1 & 2

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

theapurva 970 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,
Try using this formula,
Issue 1:
SortByColumns(Filter(QualityData,StartsWith(Title,SearchText.Text), ( (Manager.Email=User().Email)&&(Checkbox1.Value= false )||(Checkbox1.Value&&Manager.Email=CmbSearchName.Selected.Email)), ('Review Date'>=DateFrom.SelectedDate&&'Review Date'<=DateTo.SelectedDate)),"ID",Descending)

Issue 2:
you cannot send email via flow with other user's email,
you can put sender name in the body of email.
or you can send emails through the service account.

Was this reply helpful? Yes No
luaxs4 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Let me try your code snippet, however what is the best solution for emails as in when a QA submits the form, the email should go from his email box. Also if you could explain what you mean by service account and how should i go about it.

Thanks once again for this.

Was this reply helpful? Yes No
luaxs4 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Now when i use your snippet, it only throw random 3 records.

Was this reply helpful? Yes No
theapurva 970 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

these 3 records would be having manager email a current logged in user's email.
can you check the box and then try how many records are there?

Was this reply helpful? Yes No
theapurva 970 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Apologies!!
For Issue 2:
You can use action 'Send Email from a Shared mailbox' in powerautomate.

The best way is to use below action in powerapp itself instead of calling flow
Office365Outlook.SendEmail(inputTo.Text, inputSubject.Text, inputBody.Text)

Was this reply helpful? Yes No
luaxs4 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Apurva - PFA the snippet of DB. There are in total 25 records entered. So technically irrespective who is logged because the items are already entered, i should give me result. Cant share the snippet of other columns

Was this reply helpful? Yes No
theapurva 970 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
I am not sure the use of Checkbox1 in your formula,
but combobox may cause issue sometimes in filter, so you can add IsBlank function before checking the value
Considering your first formula is correct just added IsBlank(CmbSearchName.Selected.Email) in your formula
try below:
SortByColumns(Filter(QualityData,StartsWith(Title,SearchText.Text), ( (Manager.Email=User().Email)||(Checkbox1.Value= false )||(Checkbox1.Value&&(IsBlank(CmbSearchName.Selected.Email)||Manager.Email=CmbSearchName.Selected.Email))), ('Review Date'>=DateFrom.SelectedDate&&'Review Date'<=DateTo.SelectedDate)),"ID",Descending)

Was this reply helpful? Yes No
luaxs4 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Apurva - Still all records are not coming. My last 2 records are still not added in the view.

Was this reply helpful? Yes No
theapurva 970 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @luaxs4 ,
I believe then it could be the date filter issue,
Can you change the dates and then try?
Sharepoint may have different timezone, please increase 1 day in your ToDate and decrease 1 day in your From Date

Was this reply helpful? Yes No
luaxs4 58 on at

Like
a
(0)

Report
Copy link

Link copied!

I did but no change

Was this reply helpful? Yes No