Forum Discussion
How to bridge between: PowerApps->Closed Workbook & XLOOKUP->Open Workbook
As variant you may keep the file updated by PowerApps always closed. Within form file Power Query the source and load it into helper sheet which could be hided. Desirably using Power Query with entered ID filter. Fill form with XLOOKUP this helper table. Thus the process will be
- open form
- enter ID
- Refresh All
- wait for a while
- print form
Unfortunately it requires some discipline from end users with refreshing.
As variant you may keep the file updated by PowerApps always closed. Within form file Power Query the source and load it into helper sheet which could be hided. Desirably using Power Query with entered ID filter. Fill form with XLOOKUP this helper table. Thus the process will be
- open form
- enter ID
- Refresh All
- wait for a while
- print form
Unfortunately it requires some discipline from end users with refreshing.
Everything works like a charm! Thank you so much!
I had never considered using Power Query as a snapshot of the data and then into an Excel table for the XLOOKUP. Because of this, I went ahead and changed my PowerApps data source to SharePoint List instead of Excel. Much smoother interactivity.
I put a big reminder on the printout to refresh all and so far so good!