cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mwilliamsf
Level: Powered On

Powerapps with cloud excel connector (one drive)

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.
9 REPLIES 9
Community Support Team
Community Support Team

Re: Powerapps with cloud excel connector (one drive)

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:

flow.PNG

 

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.

action-tab.png

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:

Capture.PNG

 

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

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mwilliamsf
Level: Powered On

Re: Powerapps with cloud excel connector (one drive)

Thank you. Can you give me more detail in step 1?
mwilliamsf
Level: Powered On

Re: Powerapps with cloud excel connector (one drive)

 
Community Support Team
Community Support Team

Re: Powerapps with cloud excel connector (one drive)

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

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mwilliamsf
Level: Powered On

Re: Powerapps with cloud excel connector (one drive)

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
Level: Powered On

Re: Powerapps with cloud excel connector (one drive)

 
Community Support Team
Community Support Team

Re: Powerapps with cloud excel connector (one drive)

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

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mwilliamsf
Level: Powered On

Re: Powerapps with cloud excel connector (one drive)

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
Level: Powered On

Re: Powerapps with cloud excel connector (one drive)

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,568)