cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kdub86
Level: Power Up

Filtering data > sending filtered data for approval?

I'm trying to setup a workflow that:

  1. Filters data from an Excel spreadsheet
  2. Sends/emails the filtered data in an spreadsheet to an assigned person for approval

Is this possible?

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Filtering data > sending filtered data for approval?

Hi @Kdub86,

 

You could refer to screenshot below to create the flow:

Note:

You could filter the data in the condition with your expression.

Capture.PNG

Capture.PNG

 

 

The flow would run successfully as below:

Capture.PNG

 

You would receive the approval with filtered data as beow:

Capture.PNG

 

 

Please ley me know if your problem could be solved.

 

Best regards,

Alice

 

 

 

 

Kdub86
Level: Power Up

Re: Filtering data > sending filtered data for approval?

Thanks!

 

I got this error message:

  • The variable 'Filtered Data' of type 'Array' cannot be initialized or updated with value 'SMECO' of type 'String'. The variable 'Filtered Data' only supports values of types 'Array'.

Community Support Team
Community Support Team

Re: Filtering data > sending filtered data for approval?

Hi @Kdub86,

 

Could you please share a screenshot of the configuration of your flow?

 

The error message told that the value 'SMECO' of type 'String' can't be initialized or updated.

 

Please check if you have create the flow as me to append the array variable with Current item dyanmic content.

Or please update the type of the variable to String on your side to see if you requirement could be achieved.

 

Please let me know if your problem could be solved or share more details so we would try to provide a proper workaround for you.

 

 

Best regards,

Alice

JustMe84
Level: Power Up

Re: Filtering data > sending filtered data for approval?

I think I got it to work. However, the info is not formatted and that would defeat the purpose. How do I format the information within the approval email/websites so that it is easily readable?

 

Thanks

 

 email.pngEmail versionWeb.pngWeb version

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

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!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,008)