Hi,
new to flows and I am wanting to export a Sharepoint list out to a CSV file. I have used the follwoing flow options:
- Get Item from PowerApps
- Compose
- Select
- Create CSV Table
This works fine if my Sharepoint list has values in all of the Map values of the Select function. If any are empty it fails with the following error as an example
The template language expression 'body('Get_item')['RBRulesApplyJobs']' cannot be evaluated because property 'RBRulesApplyJobs' doesn't exist,
I cannot force the sharepoint list with defaults etc. as it will skew my answers in the list.
Is there a best practice way of exporting from a sharepoint to Excel using a flow(I am triggering it from Powerapps) or can someone tell me how to avoid the empty error.
I have seen some if empty statements on the web/forums but I do not understand the syntax.
Any assistance is appreciated.