Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

2 flow question

Hi all, thank you for taking your time you read this.
i have 2 flow question


1) i have a excel that is in sharepoint online.
i have set the flow to create worksheet in the excel and to have Selected data from sharepoint list to export to the worksheet.

but i am not able to have the flow to get worksheet to have the select data to export into the worksheet.

if i remove Get Worksheet, it able to put into sheet 1.


2) i am using this expense report from this person.
there is Expenses List and LineItems List
i am trying to get the lineitems Sharepoint list into the start approval part whereby it filter to show base on the expense report ID it will show what LineItems.
i know that i need to "get items" from lineitems, but for the filter how should i set it?




Community Support
Community Support

Hi @WeiMingLeong :

About the first question, I think this picture made by @DeepakS  will help you a lot:


Here is the thread's link:

Updating an excel sheet which is a subject of my Flow 

About the second question, I suggest you use the PowerAppsV2 trigger instead of PowerApps trigger.



The three dynamic parameters in start an approval action should come from get items action instead of the trigger.

Best Regards,




Hi @v-bofeng-msft ,

Do you mind explaining for the 2nd part using the powerapp V2 trigger.
do i input the text into powerapp v2 trigger?


Do i need to use the Initialize variable ?

when i add the getitem from expense list, there is no dynamic value for me to select in the filter query.


if possible can you show me an example.

Thank you!

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,396)