1. BrowserGallery sorting by which item? 2. Opening a new email in outlook by clicking on an email-link in my app, BUT open a specific email-template?

(0) Share

Report

Posted on by DoctorJaegerX42

Hello together,

1. question:

My BrowserGallery has all imported items from an excel-sheet. But the sort-button doesn't work like I would like it to. How do I find out, by which item the list gets sorted? I want the list only to be sorted by the company's name ("Firmenname").

2. question:

I want to click on the email-adress and a new email in outlook should open up. That works, but I would like to have a specific on my drive saved template with filled-in email adress to open up. Is that somehow possible?

Greetings, Doc

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (3)

Sort by

Verified answer

WarrenBelz 155,495 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @DoctorJaegerX42 ,

Question 1

SortByColumns( Search( [@Tabellel]; TextSearchBoxl.Text; "Ansprechpartner"; "Email-Adresse_x0020_fiir_x0020_Angebotsanfragen"; "Firma"; "Lieferantennuimner" ); "Firmenname"; If( SortDescendingl; Descending; Ascending ) )

Question 2 - not possible with mailto: which you are using. You could try to mimic it with a HTML body using Office365Outlook.SendEmailV2, but this will send immediately (not open up for revision and then send).

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
DoctorJaegerX42 95 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

thanks for the fast reply. I will try the first solution and close up this thread then with "Accept as Solution".

For the second topic:
In that case, I would love to have a little "Copy to clipboard" button, since I'm completely new to powerapps, sorry for that simple question 😉 How can I do that?

Was this reply helpful? Yes No
DoctorJaegerX42 95 on at

Like (0)

Report
Copy link

Link copied!

Okay, my mistake, it's not "Firmenname" but "Firma" by which the list should get sorted. But I corrected it and now it works like a charm. Thanks a lot 🙂

Now waiting for your reply on the second topic.

Was this reply helpful? Yes No
DoctorJaegerX42 95 on at

Like (0)

Report
Copy link

Link copied!

I already added a little copy-icon, but now I need the correct formula:

Was this reply helpful? Yes No
Verified answer

DoctorJaegerX42 95 on at

Like (0)

Report
Copy link

Link copied!

okay, I found it out by myself, I have to add at the "OnSelect" this formula:

Copy( ThisItem.'Email-Adresse für Angebotsanfragen' )

So my topic is completely solved! Thanks a lot!

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,495 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @DoctorJaegerX42 ,

You can use the Copy() function - so for instance if you had a Text Box name TextInput1, then

Copy(TextInput1.Text)

would put the contents of the Text Box on your Clipboard.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No