Unanswered

Extracting Data from Sharepoint List through Power Apps and Power Automate

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Everyone,

I am creating a report generator through PowerApps and using Power Automate as the flow. My problem is that when I pull the data from Sharepoint list for multiple choices columns I get an Odata error and repetition of data. These are only for multiple choices columns in Sharepoint list. Hope someone can help me fix this! Much appreciated!

Kind regards,

Pav

Categories:

General topics

All responses (5)

Answers (0)

Sort by

SamLed 2,340 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

If you want help, post screens of your flow, we need to see what you've done and what error message exactly it throws.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sam, Thanks for the reply! Please find attached screenshots of the flow and the results I'm getting. I need help in removing odata (field_8/Skills) and the original data from Sharepoint list is multiple choices and I'm getting odata error for those. Hope you can help me with this.

Kind regards,
Pav
SamLed 2,340 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Replace "Skills value" in your Select map field by "item()?['value']". Enter it from expression tab of dynamic contents.

______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sam, so the odata has been removed but the data is repeating itself. Please find below screenshots. The first row in Skills should be 'Giving and Getting Feedback' and 'Growth Mindset' but here its looping and adding it to each row.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, so the odata has been removed but the data is repeating itself. Please find below screenshots. The first row in Skills should be 'Giving and Getting Feedback' and 'Growth Mindset' but here its looping and adding it to each row.