I'm having issues creating a csv table from a SharePoint list - everything works fine except the data that comes from a drop-down list. For those fields I get the below where the final part of the string is the real data I want - 2017 in my example.
I tried to solution in the post below and it didn't work, wondering what my options are?
Here's my flow for reference:
Solved! Go to Solution.
I don't have the option for 'drop-down Value' in the dynamic content, not sure why. However, I did find a 'Benefits_Year Value' option, which appears to have worked. Any idea why I don't have the drop down option but do have the value option?
I've now noticed that the csv file that gets exported is omitting certain items from the SharePoint list. I'm looking through to see what the omissions have in common, right now all I can tell is that for some of the items in the list there aren't always values for all of the columns I've chosen to have exported - would that cause the export job to leave those rows out entirely?
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Look out for new contribution recognition badges coming SOON!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
The top training and networking event across the globe for Microsoft Business Applications