Answered

How to include a condition to check for overdue action item based on data provided in another existing column

(0) Share

Report

Posted on by GDJL

I am trying hard to figure out how to add 2 conditions and create another column for overdue actions.

Based on the due date set in another column and the response in another coloumn, to determine if the action item is overdue. Appreciate some help here and i have included the screenshot of my table.

Categories:

Building Power Apps

Capture.PNG

I have the same question (0)

All responses (2)

Answers (1)

LRVinNC 2,297 on at

Like (0)

Report

I notice your dataset screen capture is from PowerBI. Are you trying to do this condition check in PowerBi or in PowerApps? If PowerBI, I recommend posting PowerBI questions in the PowerBI forum. FYI, you can create a new column in Power BI via the modeling tab which will allow you to compare the due date to Today() and then set a value for the column.

If you are wanting to do this in PowerApps, we'll need some additional information on what your data source is to which you are trying to add the Overdue indicator. It sounds like you are wanting this to be a permanent part of the data, rather than just determining it for reporting in the app at runtime. Is that correct?

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report
Hi @GDJL ,

Could you please share a bit more about your scenario?

Do you want to check if action item is overdue based on the Due Date and the BP Actions column?

Further, do you want to update the another colum value (e.g. Comments) for the overdue action item?

Based on the needs that you mentioned, I assume that you want to check if action item is overdue based on the Due Date and the BP Actions column, and want to update the another colum value (e.g. Comments) for the overdue action item, is it true?

I have made a test on my side, please take a try with the following workaround (set the OnSelect property of the Button control to following😞

ForAll( RenameColumns( 'YourTable', "PrimaryKeyColumn", "PrimaryKeyColumn1") If( 'Due Date' < Today() && 'BP Actions' = "Completed", /* <-- Check if current loop item is overdue */ Patch( 'YourTable', LookUp('YourTable', PrimaryKeyColumn = PrimaryKeyColumn1), { Comments: "This Item has been overdue" } ) ) )

Note: The PrimaryKeyColumn represents the Primary column in your Table.

More details about ForAll function and Patch function, please check the following article:

ForAll function, Patch function

Best regards,

Was this reply helpful? Yes No