Unanswered

Powerapps with cloud excel connector (one drive)

(0) Share

Report

Posted on by mwilliamsf

I've built a Powerapp for inventory using excel on one drive. I would like to create a button that generates an email showing the item (column A), the order amount (column D, and vendor (column H). How can I achieve this? Thanks in advance.

Categories:

Building Power Apps

All responses (9)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mwilliamsf,

The send an email part need to be achieved by starting a Flow in PowerApps. Follow the below steps:

1. Create a flow like this:

2. In the app that you created using Excel table, add a button.

3. With the Button control selected, select Flows on the Action tab.

4. In the pane that appears, select the flow that you created in the previous procedure.

Note:
If the flow that you created isn't available, confirm whether PowerApps is set to the environment in which you created the flow.

5. In the formula bar, add the following:

DataCardValue1, DataCardValue4, DataCardValue8 are the 3 fileds that you want to show in the email body.

With this app, when you click on the Button, it will trigger the flow and send an email with the information you need.

Regards,

Mona
mwilliamsf 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. Can you give me more detail in step 1?
mwilliamsf 12 on at

Like
a
(0)

Report
Copy link

Link copied!
v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mwilliamsf,

1. Add the trigger "PowerApps -PowerApps"

2. Add the action > "Office 365 Outlook - Send an email"

3. In To field, fill the email address that you want to send the email to.

In Subject field, fill the subject.

In Body field, add the dynamic content "Ask in PowerApps", add 3 times.

Regards,

Mona
mwilliamsf 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Mona. I created the Button and added the content. It gives the error Invalid number of arguments.
Any ideas how to fix this?
mwilliamsf 12 on at

Like
a
(0)

Report
Copy link

Link copied!
v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mwilliamsf,

Make sure that you are point to the correct data card value. You need to select the part that contains the data label part to see the name.

Regards,

Mona
mwilliamsf 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Mona,

I am adding the correct data card but what additional dialog is included in the script? I'm still getting the same error.
mwilliamsf 12 on at

Like
a
(0)

Report
Copy link

Link copied!

In your screen capture above, I can't make out what is says in the formula bar. If you could let me know the dialog I should be good to go.

thank you