cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Highlighted
Community Support
Community Support

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.
Highlighted
Helper I
Helper I

Re: Powerapps with cloud excel connector (one drive)

Thank you. Can you give me more detail in step 1?
Highlighted
Helper I
Helper I

Re: Powerapps with cloud excel connector (one drive)

 
Highlighted
Community Support
Community Support

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.
Highlighted
Helper I
Helper I

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?
Highlighted
Helper I
Helper I

Re: Powerapps with cloud excel connector (one drive)

 
Highlighted
Community Support
Community Support

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.
Highlighted
Helper I
Helper I

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.

Highlighted
Helper I
Helper I

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,933)