Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power Automate Flow help needed please

Hello experienced Power Automate users,   I have two SharePoint lists, each with multiple columns and one of them a "calculated value". I am looking for assistance to set up the following three (3)...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Morning AnkitKukreja ,

 

We are setting up a lot of processes and yes will be transferring the excel information to SharePoint lists and putting together the analysis.

 

Please feel free to see if Power BI might be the solution. SharePoint List will have calculated value columns, so maybe in Power BI if we can create a new table (SharePoint List C) that is picking the calculated values from List A and B.

 

Also it will be great to be able to add a custom column or calculated column to that table (List C) in Power BI to carry out further analysis.

 

I cant see where to attach the excel example so I have sent you the file via LinkedIn message.

 

Thank you in advance

AnkitKukreja's avatar
AnkitKukreja
Super User
3 years ago

Hi! Anonymous 

 

I hope this helps. Pls, review the pbix file. If you have any questions pls let me know and we can connect.

I am still gonna try it with PA as this is a good example to learn. But have a look at this if this helps.
https://www.youtube.com/watch?v=jv7qpbdV77Q