cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WeiMingLeong
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
https://www.spjeff.com/2020/02/09/video-demo-powerapps-expense-report-demo/
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?

WeiMingLeong_1-1644227824488.png

 

 

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

Hi @WeiMingLeong :

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

vbofengmsft_0-1644383700323.png

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.

 

vbofengmsft_1-1644383864160.png

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

Best Regards,

Bof

 

 

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?

WeiMingLeong_0-1644904649882.png

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.

WeiMingLeong_1-1644905392609.png

if possible can you show me an example.

Thank you!

Helpful resources

Announcements
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)