- Power Apps Community
- Get Help with Power Apps
- Building Power Apps
- Common Data Service for Apps
- AI Builder
- Power Apps Governance and Administering
- Power Apps component framework, ALM & Pro Dev
- Power Apps Portals
- Power Virtual Agents Forum
- Community Blog & News
- News & Announcements
- Galleries
- Community App Samples
- Video Gallery
- Canvas Apps Components Samples
- Microsoft Business Applications Presentations
- Ideas
- Power Apps Ideas

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Power Apps Community
- Forums
- Get Help with Power Apps
- Building Power Apps
- Help needed with formula

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

MartinBlack

Level: Powered On

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-09-2019
07:18 AM

Hi all

PowerApps / Sharepoint beginner here.

I realise this is a PowerApps forum but I'm unable to move forward to PowerApps without resolving this issue with SP, so I'm hoping someone can help.

In Sharepoint I've created a list with which I intend to build an app in Power Apps.

- One of the columns in the list is called 'total'
- Another column is called 'rating'.
- 'rating' is a 'calculated' column
- In the 'rating' column I want to give a rating (number) that depends on the number in 'total'

For example:

If the 'total' is between 1 and 5 then the rating should be 1

If the 'total' is between 6 and 10 then the rating should be 2

If the 'total' is between 11 and 15 then the rating should be

I've been trying out different formulas with no success and am hoping someone here can help. I can't move on to PowerApps until I sort this, I'm pretty sure the answer is simple but at present it is beyond me.

Best wishes

Martin

Solved! Go to Solution.

2 ACCEPTED SOLUTIONS

Accepted Solutions

Pstork1

Dual Super User

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-09-2019
07:32 AM

Try the following in the rating column. Make sure both rating and total are numeric columns

=IF(source<6,1,IF(source>10,3,2))

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

Pstork1

Dual Super User

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-09-2019
09:31 AM

For that you can expand the pattern of the formula with another If statement like this

=IF(source<6,1,IF(source>15,4,IF(source>10,3,2))

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

5 REPLIES 5

Pstork1

Dual Super User

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-09-2019
07:32 AM

Try the following in the rating column. Make sure both rating and total are numeric columns

=IF(source<6,1,IF(source>10,3,2))

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

MartinBlack

Level: Powered On

Re: Help needed with formula

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-09-2019
07:48 AM

Hi @Pstork1 many thanks for the response. That formula works!

MartinBlack

Level: Powered On

Re: Help needed with formula

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-09-2019
07:52 AM

How does the forumual change if I have four ratings?:

If the 'total' is between 1 and 5 then the rating should be 1

If the 'total' is between 6 and 10 then the rating should be 2

If the 'total' is between 11 and 15 then the rating should be 3

If the 'total' is between 16 and 20then the rating should be 4

Many thanks

Pstork1

Dual Super User

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-09-2019
09:31 AM

For that you can expand the pattern of the formula with another If statement like this

=IF(source<6,1,IF(source>15,4,IF(source>10,3,2))

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

MartinBlack

Level: Powered On

Re: Help needed with formula

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-10-2019
08:27 AM

thank you

Announcements

Top Solution Authors

User | Count |
---|---|

135 | |

69 | |

60 | |

48 | |

34 |

Top Kudoed Authors (Last 30 Days)

User | Count |
---|---|

253 | |

105 | |

95 | |

90 | |

87 |