I have an SQL Server view that contains an ID and a text field. the query against the view would look something like:
select TEXT_FIELD_A from MY_VIEW_VW where ID = <requested key ID>;
I need to know how to write a FLOW for Power Apps that will read each record from the view and write the output to a text file. Additionally I need to call that FLOW from a Button on a Power Apps Gallery Form. What steps and details would be needed for the FLOW definition, and what syntax would I use to call the FLOW from the Button?
You can design the Power Automate flow the following way to read data from SQL View and create a text file on SharePoint.
Note: The Get rows action only points to SQL tables but not views, to query a view select "Enter custom table" option as shown below.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
1,495
