Is it possible to read particular data fields from Excel Using radio button option in Power Appa and Power Flow

[Anonymous]

I am new to Power APPS to Power FLOWS. At present I have below requirement.

    1. Create one radio button with header.

    2. After selecting the radio button, It needs  to read   particular  column fields  from  Excel resource and send that data            in email.

can you please help me to achieve this.

Thanks in advance.

[yashag2255]

Hi @Anonymous 

Can you please confirm where is the Excel file stored?

You can set up the configuration like:

If(Radio1.Selected.Value = 1, Office365Outlook.SendEmailV2("Email","Test",First(DataSource).Title), Radio1.Selected.Value = 2, Office365Outlook.SendEmailV2("Email","Test2",First(DataSource).'Column 2'))

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous]

Thank you for your reply , Is there any way to send entire Table in Excel  as an email using Power app.

Excel source is available in Onedrive.

[yashag2255 · Accepted solution]

Hi @Anonymous 

Yes that is possible.

You can follow the posts here:

https://powerapps.microsoft.com/en-us/blog/html-email-reporting-with-tabular-data/

https://powerusers.microsoft.com/t5/Building-Power-Apps/Data-Table-to-Email-in-PowerApps/td-p/182115

If you need help with the specifics, please share more details so that we might be able to help you better. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!