SOLVED

Using one button to trigger a flow AND open Power Apps?

%3CLINGO-SUB%20id%3D%22lingo-sub-2478268%22%20slang%3D%22en-US%22%3EUsing%20one%20button%20to%20trigger%20a%20flow%20AND%20open%20Power%20Apps%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2478268%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20know%20that%20there%20is%20a%20way%20to%20format%20a%20column%20in%20a%20SharePoint%20list%20to%20open%20to%20a%20specific%20screen%20in%20Power%20Apps%20through%20deep%20linking%2C%20and%20that%20you%20can%20trigger%20a%20Power%20Automate%20flow%20with%20a%20button%20in%20a%20SharePoint%20list%2C%20but%20I'm%20wondering%20if%20there%20is%20a%20way%20to%20do%20both%20with%20one%20button.%20I%20currently%20have%20a%20link%20embedded%20using%20the%20HTML%20formatting%20that%20directs%20to%20an%20information%20screen%20in%20Power%20Apps.%20This%20screen%20contains%20information%20from%20the%20SharePoint%20list%20item%2C%20but%20I%20also%20need%20it%20to%20include%20information%20from%20another%20source.%20I've%20written%20a%20flow%20that%20will%20gather%20and%20return%20the%20needed%20information%2C%20but%20it%20is%20currently%20being%20triggered%20by%20a%20button%20in%20Power%20Apps.%20Is%20there%20any%20way%20that%2C%20with%20HTML%20column%20formatting%2C%20I'd%20be%20able%20to%20trigger%20the%20flow%20when%20Power%20Apps%20is%20opened%20from%20the%20SharePoint%20list%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2478268%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2480432%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20one%20button%20to%20trigger%20a%20flow%20AND%20open%20Power%20Apps%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2480432%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1086437%22%20target%3D%22_blank%22%3E%40reaganbreaux%3C%2FA%3E%26nbsp%3BUnfortunately%26nbsp%3B%3CSTRONG%3ENo%3C%2FSTRONG%3E.%20This%20is%20not%20possible%20by%20creating%20a%20single%20hyperlink%20in%20list%20view%20using%20JSON.%3C%2FP%3E%3CP%3E%3CSTRONG%3EPossible%20Solutions%3C%2FSTRONG%3E%3A%3C%2FP%3E%3COL%3E%3CLI%3ECreate%20two%20separate%20links%2Fbuttons%20in%20single%20list%20column%20using%20JSON%20formatting%20-%20But%20again%20user%20have%20to%20click%20twice%20--%26gt%3B%20Not%20good%3C%2FLI%3E%3CLI%3ECreate%20a%20link%20to%20Power%20Apps%20%26gt%3B%26gt%3B%20Run%20your%20flow%20in%26nbsp%3B%3CSTRONG%3EonStart%3C%2FSTRONG%3E%20property%20of%26nbsp%3B%3CSTRONG%3EApp%3C%2FSTRONG%3E%20control%20in%20Power%20Apps%20%26gt%3B%26gt%3B%20Navigate%20to%20required%20screen.%3C%2FLI%3E%3C%2FOL%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%26nbsp%3B%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%26nbsp%3B%26amp%3B%20%3CSTRONG%3ELike%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I know that there is a way to format a column in a SharePoint list to open to a specific screen in Power Apps through deep linking, and that you can trigger a Power Automate flow with a button in a SharePoint list, but I'm wondering if there is a way to do both with one button. I currently have a link embedded using the HTML formatting that directs to an information screen in Power Apps. This screen contains information from the SharePoint list item, but I also need it to include information from another source. I've written a flow that will gather and return the needed information, but it is currently being triggered by a button in Power Apps. Is there any way that, with HTML column formatting, I'd be able to trigger the flow when Power Apps is opened from the SharePoint list?

2 Replies
best response confirmed by reaganbreaux (New Contributor)
Solution

@reaganbreaux Unfortunately No. This is not possible by creating a single hyperlink in list view using JSON.

Possible Solutions:

  1. Create two separate links/buttons in single list column using JSON formatting - But again user have to click twice --> Not good
  2. Create a link to Power Apps >> Run your flow in onStart property of App control in Power Apps >> Navigate to required screen.

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Thank you so much, I didn't even think to add it to OnStart!