OpenInAppV2

To get SiteID (guid): 'siteUrl'/_api/site/id To Get Library ID (Guid): open library settings-More Library Settings-click on Adv Settings-click on Ok at bottom and copy the content in the URL after 'List=' To get Site URL: 'root url (Tenant)/sites/'site name' (stop here nothing else) To get your User information use the User() function and then for: Email: User().Email ID: User().EntraObjectID For the DOCID for your SP library Document ID column: 1. Create new Instant flow 2. Trigger is PowerApps or manual (this function can be incorportated with the file upload flow or separate) a. Only parameter you need is the item ID after its loaded into the Library 3. If you are incorporating into your upload flow this step can be skipped: a. you will need to get your item 'Get Item' or 'Get items' depending on how you are getting it, before you can get the doc id 4. Next you will use the 'HTTP call to SP' action: a. Site url: 'site URL' b. method: GET c. URI: /_api/web/lists/getByTitle('NAME OF LIBRARY DISPLAY NAME')/items/getById(triggerbody()?['Number'])/file?$select=UniqueId,Name d: No headers or body needed for this 5. Update File Properties (library) a. Site address: 'site URL' b. Library Name: 'your library name' c. ID: same as the id in the HTTP Call to SP d. Column selection: Only need the Document ID, if no one exists you need to created it by creating a Single line of text column and naming it DocumentID (no spaces) 6. on button command: a. Launch("odopen://openFile/?fileId=" &'Document ID you pulled with the flow'& "&siteId="&gvSiteID& (Site ID variable) "&listID="&gvListID& (List ID variable) "&userEmail="&gvCurrentUserEmail& (Variable for your Email) "&userID="&gvcurrentUserID& (Variable for your ID) "&webUrl="&gvSiteURL& (variable for the site url) "&fileName="&'file name with extension' );